IBM Cognos 10

Gowri P SankariCOGNOS P r a c t i c e – Technical Team

COGNOS P r a c t i c eLearn. Adapt. Believe. Succeed with Proven Solutions.

COGNOS P r a c t i c eLearn. Adapt. Believe. Succeed with Proven Solutions.

IBM Cognos 10 : The Big Picture

IBM Cognos 10 – The Big Picture

3

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.

Cognos 10 Ready added value of TM1, Planning, Analytic Applications and SPSS Modeler

4

C O G N O S

IBM Cognos 10 – The Big Picture

IBM Cognos 10 – The Big Picture

5

IBM Cognos 10 – The Big Picture

6

Authoring studios ‘/ Report Viewer / IBM Cognos SDK sends requests to Query 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.

Broader Scope of BI

7

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.

Broader Scope of BI

8

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.

Freedom to Think Analytics everyone can use to answer key business questions

9

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

Broader Scope of BI

Unified workspace with greater power, intuitive navigation and cleaner look

10

Solution Highlights

• Pre-assembled workspace content

• Search assisted authoring

• Drag and drop assembly

• Dynamically filter

• Quicker and deeper insight into data

• Seamless graduated experience

Intuitive and easy to use, it is the single place that you go to find answers to key business questions

IBM Cognos Business InsightIBM Cognos Business Insight

Broader Scope of BI

Breadth of analytics across historical, real-time and predictive information

11

Unified Workspacedelivering breadth of analytics

Analytical ReportingDrill

Real-Time What is

Scenario ModelingWhat-if

Advanced Analytics What might be

Broader Scope of BI

Easy data inclusion by the business from one value, to entire data sets and external files

12

Combine external, departmental, and your own data to corporate information resulting in broader perspectives

External DataExternal Data

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

Broader Scope of BI

13

2

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.

New Things in Cognos 10

Seamless upgrade and ease of ongoing management

14

New Things in Cognos 10

C O G N O S

C O G N O S

Upgrade first, then leverage new features

Use LifecycleManager to

validate resultsCognos 8 and

Cognos 10

Acceptdesired results

Move business users

into Cognos 10

Use Lifecycle Manager to

validate resultsto leverage new

features

Accept desired results

Promote reports to production

Leverage Cognos 10 New Features

(e.g. Dynamic Query, etc)

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

C O G N O S

IBM Cognos Lifecycle ManagerIBM Cognos Lifecycle Manager

Reduce system management effort and speed time to deploy new functionality to the business community

15

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.

New Things in Cognos 10

Faster performance with in-memory processing

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.

Query Servicewith Dynamic Query Capabilities

Common Business Model

Logs

20+ New Patents

Modern and Legacy Sources

Application Sources

OLAP Sources

Message Sources

Relational Sources

OLAP Adapters

Relational Adapters

TM1Cubing Services

PowerCube

SAP BWMSASEssbase

DB2InformixOracle

TeradataSQLServerODBCJDBC…

IT Tools

Query Visualization

Open Data Access

Cache

3x faster query3x 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

Deliver optimized access to all data regardless of where it resides

IBM Cognos PlatformIBM Cognos Platform

Hybrid

New Things in Cognos 10

17

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

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.

Simply Do Actionable insight everywhere at the point of impact

19

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

New Things in Cognos 10

Analytics on the go for more devices and disconnected interaction

20

Provide business users with the information they need to make responsive and informed decisions regardless of their location

IBM Cognos MobileIBM Cognos Active ReportIBM Cognos MobileIBM Cognos Active Report

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

New Things in Cognos 10

21

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

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.

Connect with Others Collective intelligence to share insights and gain alignment

23

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 networking fuels the exchange of ideas and knowledge

that naturally occurs in the decision-making process

New Things in Cognos 10

Collaborative BI through built-in collaboration and social networking

24

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

IBM Cognos CollaborationIBM Cognos Collaboration

New Things in Cognos 10

25

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

New Things in Cognos 10

Thank You Thank You