IBM Cognos BI Overview

IBM Cognos BI Overview

IBM Cognos BI Overview © 2012 IBM Corporation Overview of Cognos SW Products Cognos is a suite of products to create Business Analytics, Business I...

1MB Sizes 4 Downloads 22 Views

IBM Cognos BI Overview

© 2012 IBM Corporation

Overview of Cognos SW Products Cognos is a suite of products to create Business Analytics, Business Intelligence and Financial Performance Management (FPM) Solutions  IBM Cognos 10.1 BI  All Business Intelligence capabilities, One platform.  IBM Cognos TM1  For Financial Performance Mgmt (FPM); enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications, using highly complex data (OLAP cubes)  IBM Cognos 10.1 Planning  To create, compare and evaluate business scenarios, conditions, drivers, rates and assumptions and use best practices such as driver-based planning and rolling forecasting to determine resource requirements, operating performance and future business results in real time  IBM Cognos Real-Time Monitoring  For real-time monitoring of key performance indicators (KPIs) ans operational metrics from disparate data sources. IBM Cognos Controller  Financial consolidation software that supports the complete close, consolidate, report process. IBM Cognos Analytics Applications  Packaged business analysis and reporting solutions  IBM Cognos Consumer Insight  Enables marketing professionals to be more precise, agile and responsive to customer demands and opinions expressed through social media. Full product portfolio http://www-01.ibm.com/software/data/cognos/

Cognos Performance Management System

Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Information Infrastructure

Why are we doing it?

How are we doing? What should we be doing?

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Event Studio Creating and tracking alerts and events

Cognos Metadata Modeling Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS BI Components Cognos Analytical Applications Applications & Blueprints

Access & Interactivity

Universal Capabilities

Business Modeling Performance Management Platform

Workforce Performance Analytics

Financial Performance Analytics

Procurement Analytics *

Sales Analytics *

Banking Credit Risk Analytics

Cognos Consumer Modes

Cognos Connection Out-of-the-box Portal to search & consume BI

Business Insight Webbased user experience to interact and assemble dashboards

Active Report Fully interactive & Intuitive standalone reports

Mobile On Extends Cognos to mobile devicesincluding iPad & iPhone

Cognos Authoring & Analysis Environments Analysis Query Studio Studio Business user Business user report data exploration authoring

Report Studio Professional report and dashboard authoring interface

Business Insight Advanced New ad-hoc query & self-service reporting & analysis

CAFE Data Metrics Studio exploration Measuring and and analysis monitoring key in Excel metrics and impacts

Cognos Metadata Modeling

Event Studio Creating and tracking alerts and events

3

Framework Manager - Define and model a business representation of the data sources to be used for BI

Data Access

Dynamic Query Mode

MDX

SQL

ODBC

Information Infrastructure

Relational (Oracle, SQL Server, Teradata, SAP BW, DB2, etc.)

OLAP (Powercubes, TM1, Essbase, MSAS, etc.)

Others (Transactional, Legacy, Files, Web Services, etc.)

 OLAP (Powercubes and TM1) – Multidimensional OLAP data stores  Transformer – Modeling tool to automate the process of build and managing Powercubes  Data Manager – ETL design tool to move data from one data source to another for BI  Virtual View Manager (Composite) – Access modern and legacy based data sources

COGNOS Financial Performance Management Components Performance Management Cognos Financial Cognos Financial PM Performance Application Blueprints Finance & Administration

Operational PM Sales

Marketing

HR

Inventory

Distribution

Solutions Controller

Planning

Strategy Mgmt

Operational BI

Scorecarding

Reporting

Analytics

Profitability

Business Intelligence

Dashboarding

Access & Interactivity

Universal Capabilities

Enterprise Planning (TM1) Automate and optimize the budgeting, planning, and forecast cycle

Financial Reporting & Analytics TM1 – In-memory planning and analytical engine for dimensional analysis with write-back

C10 BI – Full range of BI capabilities to meet the needs of the enterprise

Scorecarding (Metrics Studio) Performance measurement environment for metrics, impact diagrams, alerts, initiatives, strategy maps, etc.

Controller Corporate consolidation to minimize errors, improve data quality, and improve close cycle times

Business Modeling Performance Management Platform

Information Infrastructure

TM1 OLAP – 64-bit in-memory analytic and planning server • Multi-dimensional • Complex business logic • High data scalability

Cognos Controller

Relational / OLAP / More