IBM Cognos 10 Gowri P Sankari COGNOS P r a c t i c e – Technical Team

1. IBM Cognos 10 Gowri P Sankari COGNOS P r a c t i c e – Technical Team COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions.

2. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. IBM Cognos 10 : The Big Picture

3. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. IBM Cognos 10 – The Big Picture IBM Cognos 10 is the first major BI release since Cognos 8 was released in 2005. Cognos 10 presents a more integrated user interface along with a broader offering of analytics and technology. The recent acquisitions by IBM of SPSS, TM1 (Applix) and Clarity are now part of the offering.

4. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Cognos 10 Ready added value of TM1, Planning, Analytic Applications and SPSS Modeler IBM Cognos 10 – The Big Picture C O G N O S

5. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. IBM Cognos 10 – The Big Picture

6. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. IBM Cognos 10 – The Big Picture • Authoring studios ‘/ Report Viewer / IBM Cognos SDK sends requests toQuery Planning Layer for processing. • Query Framework ( QFW ) of Query Planning Layer will process • OLAP Style Queries from studios into OLAP Query Planner. • Relational Style Queries into Relational Query Planner. • Dimensionally Modeled Relational Queries into DMR Query Planner. • OLAP Query Planner generates MDX query and send it to MDDS(multidimensional data service) • Relational Query Planner generates SQL query and send it to UDA(universal data access ) • DMR Query Planner generates a Temporary Cube through Cube Build Request. New OLAP Style Query generated will be sent to be processed in Temporary Cube. • MDDS or UDA processed queries will be sent to IBM Cognos BI supported Data Sources through interfaces like ODBC or XMLA.

7. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Broader Scope of BI • IBM Cognos 10 is a bold move to broaden its scope beyond BI to include group decision making, integrated statistics and mobile BI. • The goal is to focus on integrating a broader role for BI into the decision making process with the ability to actually record and track decisions and then measure results against them. • Cognos 10 is also a move away from role defined capabilities and the whole issue of "studio clutter" that confused some of its BI users in the past. Business Insight as it's called, enables users to aggregate and organize BI with analytic and planning content within a unified interface.

8. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Broader Scope of BI • Users can access increased functionality without having to change studios or interfaces Why Cognos 10 and not Cognos 9? :The most consistent answers here centered around two areas: • First, it's considered a major release and thus warrants being a 10 not a 9. • Second, TM1 (Applix) already has a 9.x release on the market.

9. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Freedom to Think Analytics everyone can use to answer key business questions Broader Scope of BI • Cognos 10 advances • Combine data from any source and explore it from any perspective without limitation • Analyze facts and anticipate outcomes simply by shifting perspectives and time horizons. • Expand expertise beyond traditional BI capabilities without switching tools • Enable business to increase their personal productivity and independence from IT • Key features • Intuitive, appealing Web 2.0 interface • Personalized, progressive interaction • Drag-and-drop, free-form assembly • Search-assisted authoring • Wizard-driven external data • Automatic access to SAP BW queries • In-space access to planning, scenario modeling, real-time monitoring and predictive analytics The new BI workspace supports the way you think, so you don’t have to interrupt your train of thought to fit the software

10. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Unified workspace with greater power, intuitive navigation and cleaner look Broader Scope of BI IBM Cognos Business Insight Intuitive and easy to use, it is the single place that you go to find answers to key business questions • Solution Highlights • Pre-assembled workspace content • Search assisted authoring • Drag and drop assembly • Dynamically filter • Quicker and deeper insight into data • Seamless graduated experience

11. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Breadth of analytics across historical, real-time and predictive information Broader Scope of BI Unified Workspacedelivering breadth of analytics Real-Time What is Advanced Analytics What might be Analytical Reporting Drill Scenario Modeling What-if

12. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Easy data inclusion by the business from one value, to entire data sets and external files Broader Scope of BI External Data Combine external, departmental, and your own data to corporate information resulting in broader perspectives • Solution Highlights • Import external data sources into reports or query subjects • Leverage external data as report filters • Publish for reuse and update • Provide IT governance

13. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. 2 New Things in Cognos 10 • Life Cycle Management : • The capability to handle upgrades from one version to another. • It is now possible to run reports and queries in both Cognos 8 and Cognos 10 at the same time and then compare the processing differences. This should reduce the testing needed in version upgrades.

14. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Seamless upgrade and ease of ongoing management New Things in Cognos 10 IBM Cognos Lifecycle Manager Reduce system management effort and speed time to deploy new functionality to the business community Use LifecycleManager to validate results Cognos 8 and Cognos 10 Move business users into Cognos 10 Acceptdesired results C O G N O S Solution Highlights • Validate single environment • Assess impact of change in operating environment, (e.g. refresh pack, data source changes) • Compare multiple environments • Streamline upgrade process and increase IT efficiency • Use beyond upgrade to quickly assess impact of any change that could effect BI content Leverage Cognos 10 New Features (e.g. Dynamic Query, etc) Use Lifecycle Manager to validate results to leverage new features Promote reports to production Accept desired results C O G N O S C O G N O S Upgrade first, then leverage new features

15. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. New Things in Cognos 10 Dynamic Query: This is a new feature that results from performance enhancements. With this feature enabled, reports, queries and cube building are shortened. This is done by caching and query routing techniques. Results indicated performance improvements of up to 30 to 40 percent.

16. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Faster performance with in-memory processing New Things in Cognos 10 20+ New Patents IBM Cognos Platform Common Business Model Query Servicewith Dynamic Query Capabilities Deliver optimized access to all data regardless of where it resides IT Tools Query Visualization Cache Hybrid Logs Solution Highlights • Enhanced Query Service with Dynamic Query: • 64-bit in-memory optimized query generation with pattern intelligence to improve performance against complex heterogeneous data • In-memory calculations and aggregate operations for faster compute time • New optimized caching for hierarchies, members, facts, calculations and prompts for improved report performance • Initial conformance is for OLAP sources: SAP BW, TM1 and Essbase. Open Data Access OLAP Adapters Relational Adapters • TM1 • Cubing Services • PowerCube • SAP BW • MSAS • Essbase • DB2 • Informix • Oracle • Teradata • SQLServer • ODBC • JDBC… Modern and Legacy Sources Message Sources Relational Sources Application Sources OLAP Sources 3x faster query * When compared against IBM Cognos 8 BI software. Based on selective results from tests conducted in the IBM Performance and Scalability Labs on pre-release Cognos 10 software

17. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. New Things in Cognos 10 Statistical Integration: It is the result of SPSS being integrated into the analytics umbrella of Cognos 10. SPSS has added a Modeler capability making it easier for non-statisticians to benefit from predictive modeling in a much broader business context, increasing the potential for improved business performance. Those with the skills to harness its power can get some big benefits quickly.

18. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. New Things in Cognos 10 Active Reports: Allow users to receive self-contained interactive reports by email. This extends the reach of BI to mobile and offline workers that can work on these active reports and perform what-if scenarios if required. Mobile workers are the fastest growing market segment for BI and making it easier for them to work anywhere keeps the market growing.

19. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Simply Do Actionable insight everywhere at the point of impact New Things in Cognos 10 • Cognos 10 advances • Adopt mobile to accelerate delivery of interactive analytics to executives and the frontlines • Address challenges of compressed decision cycles with real-time analytics • Integrate analytics in everyday work and in workflow to inform business processes • Key features • Mobile interaction on iPhone and iPad • Interactive, disconnected reports • Real-time monitoring of in-flight information • Mashups • Business-driven workflow Mobile, real-time, and portable BI transforms BI from a separate task, to BI informing everything you do

20. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Analytics on the go for more devices and disconnected interaction New Things in Cognos 10 IBM Cognos MobileIBM Cognos Active Report Provide business users with the information they need to make responsive and informed decisions regardless of their location • Solution Highlights • Mobile • iPhone, iPad, BlackBerry, Windows Mobile, and Symbian • Full BI interactivity including Drill Up/Down/Through • Schedule reports for immediate access to key content • Active Report • Disconnected BI application, fun and fast • Self-contained, interactive content • Burst distribution to reach wide audiences

21. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. New Things in Cognos 10 Platform Enhancements: Designed to make life easier for those that have to support the platform. These include optimized query generation, life cycle management and performance enhancements. As BI environments have grown in size throughput has become more of an issue, these enhancements help minimize potential bottlenecks as more users are added to the environment.

22. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. New Things in Cognos 10 Social Networking: This is achieved with the integration of Lotus Connections and Business Analytics. With IBM Cognos 10, key information can be shared by groups or communities and forms the basis for decision making that connects people to the event. All of this is captured and used to improve decision making practices.

23. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Connect with Others Collective intelligence to share insights and gain alignment New Things in Cognos 10 • Cognos 10 advances • Engage others in decision networks to discuss issues, share insights and align decisions • Attach business context to BI content and learn from a growing repository of decision history • Support workflow to establish accountability and engage the right people at the right time • Key features • Annotations down to cell level • Lineage and data stewardship • Threaded discussions associated with BI evidence • Activities, notifications, tasks, and initiatives • Search threads, people, discussions, decision history Built-in collaboration and social networkingfuels the exchange of ideas and knowledge that naturally occurs in the decision-making process

24. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Collaborative BI through built-in collaboration and social networking New Things in Cognos 10 IBM Cognos Collaboration Quickly find the people and expertise you need. Discuss and refine ideas with colleagues, partners, and customers. • Solution Highlights • Embed of Lotus Connections • Post messages, share files and links to web content (both BI and external) • Create and assign to-do items • Work within Business Insight workspace to drive activities or requests for action • Send email notifications directly from an activity

25. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. New Things in Cognos 10 • Cognos 10 - To sum it all up: • Broader role for BI - BI has now become Business Analytics. • More unified user interface with integrated analytics. • Improved performance and platform enhancements. • Social networking that enables collaborative decision making. • _________________________________________________________________________________ • Also refer :http://www.cognos-bi.info/cognos10.html

26. COGNOS P r a c t i c e Learn. Adapt. Believe. Succeed with Proven Solutions. Thank You