trainersrinivas@gmail.com   8121985889

Cognos

Ø  Introduction to cognos

Ø  Difference between OLTP and OLAP systems

Ø  Overview on relational and dimension model

Ø  Introduction to cognos architecture

Ø  Overview on cognos components

Ø  Introduction to framework manager

v Create a project:

Ø  Working with various data sources:

§  MS-Access

§  MS-SQL Server

§  Oracle, etc.

Ø  Create a relational model in FM:

§  Import tables

§  Understanding the tables

§  Understanding balanced and ragged-hierarchies (balanced)

§  Define the relations

§  Set the cardinalities

§  Create shot cut joins

§  Verify the referential integrity

§  Validate the tables and model

Ø  Create a query subject in FM:

§  From model

§  From same database

§  From different database

§  From stored procedure

§  Define granularity

Ø  Create new query items:

§  Using necessary operators and functions

§  Define additive measures

§  Semi-additive measures

§  Non-additive measures

Ø  Create a cube in FM:

§  Create regular dimensions

§  Difference between normalization and de-normalization

§  Define hierarchies with business keys

§  Define suitable member captions to business keys

§  Create measure dimensions with necessary aggregate functions

Ø  Create global filters in FM:

§  Simple filters

§  Complex filters

Ø  Validate the project

Ø  Create package and publish:

§  With necessary query subjects

§  Query items

§  Query filters

§  Select style of the request model.

 Reporting Services:

Ø  Overview on various types of reports:

§  Ad-Hoc

§  Standard

§  Dashboard

Ø  Working with cognos connection

Ø  Introduction to various reporting tools in cognos connection

§  Report Studio

§  Query Studio

§  Analysis Studio

§  Event Studio

§  Metric Studio

Ø  Working with cubes and reports:

Ø  Overview on Report studio:

Ø  Explanation on various report formats

v Create reports in Report Studio:

§  List reports

§  Cross-tab reports (matrix or pivot table)

§  Chart reports

§  Map reports, etc

§  Generate the reports in PDF, Excel, HTML, etc.

§  Working with prompts and filters

§  Working with aggregated function

§  Report optimization

§  Working with repeatable tables

§  Create Group reports (Dash board)

Ø  Working with Query Studio:

§  Generates various types of Ad-hoc reports

§  Working with arithmetic operations and aggregated functions

§  Create new query items

§  Difference between native SQL and Cognos SQL

Ø  Overview on drilling analysis

Ø  Overview on Analysis Studio:

§  Create multi-dimensional reports

§  Using drill-down and drill-up options

Ø  Working with event studio

Ø  Overview on metric studio