Scribd
Upload
35 views24 pages

Business Intelligence in IBM Cognos 10: Framework Manager Business Insight Advanced Business Insight

The document introduces IBM Cognos 10 business intelligence tools including Framework Manager, Business Insight Advanced, and Business Insight. It describes creating a virtual machine with DB2 data warehouse containing sales data. Models and dashboards were created in Framework Manager and Business Insight Advanced to analyze the sales data in an interactive dashboard in Business Insight. The document concludes with an overview of the different Cognos 10 tools and their target users.

Uploaded by

Babjee Reddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
35 views24 pages

Business Intelligence in IBM Cognos 10: Framework Manager Business Insight Advanced Business Insight

The document introduces IBM Cognos 10 business intelligence tools including Framework Manager, Business Insight Advanced, and Business Insight. It describes creating a virtual machine with DB2 data warehouse containing sales data. Models and dashboards were created in Framework Manager and Business Insight Advanced to analyze the sales data in an interactive dashboard in Business Insight. The document concludes with an overview of the different Cognos 10 tools and their target users.

Uploaded by

Babjee Reddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 24

Matou Havlena

matous@havlena.net
Shahabedin Hassani
shahabedin.hassani@gmail.com

Business Intelligence in
IBM Cognos 10
Framework Manager
Business Insight Advanced
Business Insight

Business
Insight
Advanced

Framework
Manager

Demo

Business
Insight

Conclusion

1. Step: DB2 Datawarehouse

We got DB2 database with Fact and Dim tables

2. Step: Creation of VMware Image

Contains Windows 7, DB2, Cognos 10

3. Step: Creation of Dashboards

Interactive dashboards that analyze sales

Introducing IBM Cognos 10


Framework
Manager

Desktop application for importing data definitions and modeling that


information to provide simplified data access for business reporting and
analysis. Models can be published as packages and deployed to Cognos 10,
where users can create reports based on the package content.

Business
Insight
Advanced

Web-based tool that allows you to analyze your data. The user interface is
designed to help business users gain insight into their business. You can
create reports with relational or dimensional data sources, and than show
data in lists, crosstabs, and charts.

Business
Insight

Web-based tool which allows you to use Cognos content and external data
sources to interact, analyze and build sophisticated interactive dashboards
that facilitate collaborative decision making.

Architecture
Dashboard for
Sales Analysis

...

Report Order
Revenue

...

Report Order
Cancellation

Business
Insight

Report Sales
Trend

...

Business
Insight
Advanced

Cognos
Content

Package

Framework Manage

Sales Analysis
Model

DB2
DW

DIM
table

DIM
table

DIM
table

DIM
table

DIM
table

FACT
table

FACTt
able

...

Spectrum of users
DB Specialists

IT

Administrators

Professional Authors

Business and Financial Analysts


BUSINESS

Business Managers

Casual Employees and Consumers

Data Manager

Framework Manager

Report Studio Pro

Business Insight Advanced, Business Insight, TM1

Business Insight, Collaboration

Office, Mobile, Active Reports, Portal

Framework Manager
DB2 Data
Source

Create Project

Import Metadata

Model Metadata
and Prepare the
Business View

Create and
Manage
Packages

Publish Package
Cognos Business
Insight Advanced

Content
Store

Importing data definitions

Physical View and New Calculated Column

Building Business View - Dimensions

Building Business View - Measures

Presentation View in Diagram

Creating and Publishing Package (model)

Business Insight Advanced

Content
Store

Select Package
(model)

Create and
Manage Report

Report

Save Report

SQL (created by
model)

DB2 Data
Source

Creating Reports within the Model

Creating Reports within the Model

Creating Reports within the Model

Business Insight

Content
Store

Create
Dashboard

Import Reports
(or part of them)
as Widgets

Create Filters

Report

SQL (created by
model)

Save Dashboard

DB2 Data
Source

Interactive Sales Analysis Dashboard

Demo

Resources

IBM Cognos Business Intelligence V10.1 Handbook


https://www.redbooks.ibm.com/redbooks.nsf/RedbookAbstracts/sg247912.html?Open

IBM Cognos Business Intelligence 10.1.0 Documentation


http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0

Proof of Technology: Experience Business Intelligence with IBM Cognos 10


presentations, workbook (not available online)

Matou Havlena
matous@havlena.net
Shahabedin Hassani
shahabedin.hassani@gmail.com

Thank you!
Questions?

You might also like