ibm cognos b iund pmfj

© 2010 IBM Corporation1 SWG Information Management12.04.231

IBM Cognos BI & Performance Management

Friedel Jonker, Manager Business DevelopmentAnalytics & Performance Management


The Business Application Foundation

‘Lights-On’ investments (availability/scalability) Fixed structure and processes Operations-centric (day-to-day transactions)

CO

MP

ET

ITIV

E A

DV

AN

TA

GE

TRANSACTION PROCESSES

TRANSACTION PROCESSES

Set goals and strategies, manage exceptions,react to market changes

Dynamic and ever-changing – iterative & collaborative Multiple, cross-functional sources for

complete understanding

MANAGEMENTPROCESSES

MANAGEMENTPROCESSES


Consolidation within the BI & PM Market


Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling

Performance Management Platform

Information Infrastructure

IBM Cognos Performance Management System





Business Modeling


IBM Cognos Performance Management System – Performance Management Platform




Business Modeling


Information Infrastructure

IBM Cognos Performance Management System – Universal Capabilities


Applications& Blueprints



Business Modeling

PerformanceManagement

Platform

Data Access Strategy

Modern and Legacy Sources

Application Sources(SAP, Lawson, Oracle, etc)

OLAP Sources(SAP BW, Essbase)

Message Sources

Relational Sources

Open data access


IBM Cognos Performance Management Platform

Exploit existing infrastructure choices Integrated & optimized with IBM infrastructure

Metadata

Content

Security

Services API

Content

Model

Admin

Upgrade

IT Tools

Shared Dimensions

Personal Datasets

Plan & Report Saved Objects

QueryService

MovementService

Calculation Service

Presentation Service

EventService

Streaming Service

Shared Set of Purpose-Built Services

Security Service

Cognos 8 Bus – Dispatcher SOAP, XML

SchedulingService

Attachments, Annotations

Data Integration & Data Quality Tools

Platforms & Databases

Security Providers & Firewalls

Application & Web Servers

Cognos 8 Architecture

User Experience

Infrastructure Fit

Universal CapabilitiesAccess and Interactivity Business Modeling

Modern and Legacy Sources

Application Sources

OLAP Sources

Access to All Data

Message Sources

Relational Sources

Open Data Access

Common Business Model

Initiatives, Metrics

System ContentMetadata, Events Search Index, Audit Logs, System Metrics

Optimized OLAP64-bit in-MemoryHigh PerformanceStreaming Cache

© 2010 IBM Corporation10

SWG Information Management12.04.23

IBM Cognos LineageHistory of Integration and Interoperability with SAP® Applications

Certified solutions since 1997 One of the first BI vendors to achieve

“Powered by NetWeaver” certification Historical & ongoing commitment to certification of Cognos software components Leverage expertise as part of over 35 IBM products that are SAP certified solutions Cognos software as part of

IBM Competency Centers focusedon SAP® applications

SAP, SAP NetWeaver and SAP R/3 are registered trademarks of SAP AG in Germany and in several other countries.



Cognos Software CertificationsSAP NetWeaver Components

IBM Cognos 8v4 Interoperability with SAP NetWeaver®

SAPNetWeaver® Portal

SAP®

Web Application Server

SAP NetWeaver® Business Warehouse

Enterprise Portal iViews (EP-BP)

SAP Web Application Server

(J2EE-DEP)

OLAP BAPI interface

SAP BW (BW-OBI)

SAP® Business Suite (ECC) SAP ERP Central Component 6.0

SAP, SAP NetWeaver and SAP R/3 are registered trademarks of SAP AG in Germany and in several other countries.



Integration with SAP NetWeaverTM Portal

Browse

Content

Search

Content

View

Specific

Content

View

AlertsView

Metrics



SAP R/3 and ECC (SAP ERP transaction system)

Virtual View Manager for SAP R/3 and ECC– Out-of-the-box connectivity to all mySAP modules– Provides extensibility for additional BI authoring– Leverages RFCs and BAPIs (SAP Certified Interface)– Supports any language– Delivered as part of Cognos 8 BI license– 3 Components (server, studio & data services for SAP)– Supported SAP version (4.6, 4.7, 5.0, 6.0)



Virtual View Manager vs. Information Server?

Cognos Component Virtual View Manager Informations Server

Feature EII tool ETL tool

SAP R/3 & ECCYes

(4.6, 4.7, 5.0, 6.0)Yes

(4.5, 4.6, 4.7, 5.0, 6.0)

License Part of C8 BI (bundled)Separate license (LP:

US70K@2CPU)

SAP Transports No Yes

Advantage Real-time access Alternative to SAP BW



InfoObject

Remote CubeODS ObjectInfoCube InfoSet

SAP BW InfoProvidersSAP BW InfoProvidersSAP BW InfoProvidersSAP BW InfoProviders

MultiProvider

BEx Queries

InfoProvider

Leverage Business Warehouse metadata and business content Access to all Business Warehouse structures Strong MDX support and hierarchy awareness BEx Variable support Reusing BEx business logic Currency Conversions Measure Formatting

Embracing and enhancing SAP BW



IBM IBM Cognos 8

Optimized MDX

MDX Processor

SAPBW

IBM CognosSAP Provider

SAP NetWeaver

OLAP Processor

OLAP

BAPI

Metadata requests

Metadata requests

Metadata requests

1

2

3

4

US Patent Application: 155A - Multidimensional Query Simplification Using Data Access Having Local Calculation Engine

Cognos allows unique tuning of our engine to accommodate complexities of SAP BW– Adjusting for using MDX or BAPI– Compensate for data sparsity– Overcome SAP’s limits around data volumes

Next Generation Access to SAP BW



Current Ways to Improve BW Query Performance

BWAccelerator

Aggregat

esOLAPCache

ReportingEvent

ManagementContent

SchedulingIBM DB2

Summarized (or subset)materialized views ofInfoCube data

Accelerates response for similar queries by caching query result sets, and reading from cache instead of DB

Run popular queries in background(off hours) and push summary views of updated data to users – via IBM Cognos 8

Exploit DB2 Performance Features for SAP BW



IBM Cognos 8 Integration & Interoperability with SAP BW

Indexed InfoCubes

11

22

33

44

55

66

IBM Cognos 8 SOA

ITTools Shared Set of

Purpose-Built Services

Open Data Access

ServicesAPI

Business Content

Common Business Model

BusinessWarehouse BWA

OLAP BAPI



Infrastructure

IBM Cognos 8 BI

IBM Cognos 8

Studios

InfoCubes & MultiProviders DataStore-Object

SAP ERP Other Data Sources

SAP BW/BI

MS Excel / TM1 Web

Non-SAP Data Sources

IBM Cognos TM1IBM Cognos TM1

TM1 Turbo Integrator (ETL)

64bit cube in memory technology

TM1 SAP Connector

Non-SAP Data Sources



Design Principles for BI & Performance Management

IT ownership Biz ownership

Model driven FutureInternal Information

Past External InformationData driven



Design Principles: SAP BW and TM1

IT ownership Biz ownership

Future

Past External Information

Internal Information

SAP BW(ROLAP)

IBM CognosTM1

(OLAP)

Data driven

Model driven



TM1 for IBM Cognos 8

Features

• Plug & Play Portlets

• Writeback

• Financial Intelligence

Benefits

• Real-Time Reporting

• What If Scenarios

• Offline Reporting



Lade- und Kalkulationszeit in Minuten

173,3

105,7

87,7

18

2,9

0 20 40 60 80 100 120 140 160 180

SAP BW

Cognos Analysis

Orace Essbase

BPC (OutlookSoft)

IBM Cognos TM1

(Note: This chart, based on Median Load/Calculation Time in the OLAP Survey 6 data, was created by IBM Cognos.)



SAP BW & BWA vs. TM1 and PowerPlay



IBM & SAP: The Value of a Partnership

Strategic relationship for both companies 300 IBMers located in Walldorf (SAP Headquarter) IBM SAP Competency Centers Importance of DB2 as the database for SAP systems and as competitive differentiator to

Oracle IBM has over 36 integrations with SAP

– Cognos, Lotus, Websphere, InfoSphere (Ascential) etc.. New solutions such as BI Accelerator & Alloy for Lotus Notes Joint Marketing & Go To Market Activities



Additional Information

IBM Cognos Software Website:– http://www-01.ibm.com/software/data/cognos/solutions/sap

View customer webinars with Tellabs®, FirstEnergy® & Nike®– http://www-01.ibm.com/software/data/cognos/solutions/sap/library.html

Whitepapers– IBM Cognos 8 Business Intelligence Software and

Business Warehouse Accelerator

– IBM Cognos 8 Unlocking Hidden Value from theBusiness Warehouse



© Copyright IBM Corporation 2010 All rights reserved. The information contained in these materials is provided for informational purposes only, and is provided AS IS without warranty of any kind, express or implied. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, these materials. Nothing contained in these materials is intended to, nor shall have the effect of, creating any warranties or representations from IBM or its suppliers or licensors, or altering the terms and conditions of the applicable license agreement governing the use of IBM software. References in these materials to IBM products, programs, or services do not imply that they will be available in all countries in which IBM operates. Product release dates and/or capabilities referenced in these materials may change at any time at IBM’s sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future product or feature availability in any way. IBM, the IBM logo, Cognos, the Cognos logo, and other IBM products and services are trademarks of the International Business Machines Corporation, in the United States, other countries or both. Other company, product, or service names may be trademarks or service marks of others.

ibm cognos b iund pmfj

Documents

sap applications sap

sap version

olap sources sap bw

sap transports yes4

nonsap flat

transaction systems

bapis sap certified

business content access