introduction cognos8

8/6/2019 Introduction Cognos8

1/19

Introduction to Cognos8

Beget Software Solutions


2/19

In This Session,

You are going to learn:

What is Cognos8? Why Cognos8?

Advantages of Cognos8

Components of Cognos8

Work Flow of Cognos8

Beget Software Solutions, www.begetsoft.com


3/19

Why Cognos8?

Decision Making involves three fundamentalQuestions..

How is the business doing?

Ex: What is the total revenue, profit

Why is it done like that?

Ex: What are the reasons for downfall of profit?

What should be done instead? Ex: What are the measures that should be taken to get more

profits

A single platform to provide answers to thesequestions is Cognos8



4/19

What is Cognos8

Cognos8 is a web based Enterprise businessintelligence software with integrated reporting,scorecarding, analysis and event managementcapabilities.

Cognos8 takes decision making to the nextlevel of efficiency, simplicity and costeffectiveness which makes the job easier toperform

Cognos8 can perform Business Intelligenceacross multiple data sources and Applications



5/19

Advantages

Scalable to Hundreds and Thousands of users

Can create reports in multiple languages Can Send the reports to multiple users online

OLAP cubes, Dimensional Data sources andRelational databases can be accessed in asingle interface

Can be integrated with any ProgrammingLanguage.



6/19

Cognos Products at a glance!

Cognos Impromptu

Cognos Powerplay Cognos Decision Stream

Cognos Data Manager

Cognos Reportnet 1.1 Cognos 8 BI (Reportnet1.1 + powerplay)

Cognos Enterprise planning



7/19

Components of Cognos8

User Interfaces are mainly Web based (accessed through Internet explorer)

Windows based

Framework Manager

Cognos Powerplay

Map Manager

Metric Designer

Query Studio

Event Studio

Analysis Studio

Report Studio

Metric Studio

Cognos Connection



8/19

Accessing Components

Access Different Web based interfaces usinginternet explorer.

URL: http:///crn orhttp:///cognos8. if the server isinstalled on local machine, usehttp://localhost/cognos8

Access windows based interfaces: Start button -> Programs-> cognos8-> Framework

manager / cognos configuration etc.

http://localhost/cognos8http://localhost/cognos8


9/19

Components

Query Studio is used to create simple queriesand reports. Basic templates and formattingcan be applied.

Analysis Studio is used for data analysisthrough ranking, complex filters for largevolumes of data

Metric Studio is used to create score cardingand dash board reports, assign tasks for poorlyperforming metrics and liking to reportscontaining related information.



10/19

Example Reports



11/19

Example Scorecard

KPI Planned Actual Variance Tolerance

Revenue 2Million 1.8million -10% 20%Profit 2lacs 1.5lacs -25% 20%

No. ofBranches

10 12 20% 10%

Manufacturing units

25 20 -25% 20%

No. OfCustomer

25k 20k -25% 5%



12/19

Components

Report Studio Is used to create professionalstandard reports including dashboards, maps,charts etc., fully automated drill throughs areavailable.

Event Studio has agents that check the data.When an agent detects a particular condition,Event studio takes action by generating emails,running reports etc..

Cognos Connection is used for managingcontent and administration of cognos server.



13/19

Windows Based Components

Framework Manager used to create packages basedon relational, dimensional cubes. Packages are

published to cognos connection which will be used tocreate reports in various studios.

Powerplay transformer Used to create powerplaycubes.

Map Manager Used to create user defined maps.

Metric Designer Used to create metrics which are usedto create scorecards in metric studio



14/19

Work Flow of Cognos8

Three Approaches of Development

Relational Models: Based on relational databaseslike oracle, db2. generally use SQL

Dimensionally modeling a relational database(DMR): used to provide dimensional approach toa relational database

OLAP Sources: Publishing packages based onCubes.



15/19

Relational Model

Database(oracle, db2) (metadata)

Framework Manager(Query subjects, Query items)

Report Server(Cognos Connection)

Packages

Studios like

Query studio

SQLQuery

Data

No Analysis Studio



16/19

Dimensionally Modeling a Relational

Database


Framework Manager(Regular Dimension,Measure dimension)


Packages

Studios like

Query studio

MDX ->SQLQuery

Data



17/19

OLAP Sources


Framework Manager(Query subjects, Query items)

Cognos PowerplayTransformer

IQDs

Powerplay Cube


Packages

Studios like

Query studio

Framework Manager



18/19

Questions

What is the component of Cognos8 which will

be used for generating standard reports? Answer: Report Studio



19/19

Question

What are the different approaches for

development of cognos reports? Answer:

Relational Models

Dimensionally modeling a relational database

(DMR) OLAP Sources


introduction cognos8

Documents