This course will benefit all personnel tasked with setting up and maintaining Cognos Business Intelligence (BI) Framework Manager.
NOTE: This course is applicable to both Cognos 8 and 10.
There are no specific prerequisites for this course, however an understanding of Cognos BI would be greatly beneficial.
2 days. Hands on.
This course is available on site only. Please call for details.
This course is designed to introduction to the key concepts required to build and use Cognos BI Framework Manager. It provides attendees with the knowledge necessary to model metadata with Framework Manager and publish packages for report users.
Throughout the course, delegates will model both operational and star schema metadata for predictable results, as well as create a dimensional model to be used for OLAP style querying. Finally, they will import, manage, and publish OLAP data sources
Framework Manager Introduction
The Project Interface.
Creating data sources.
Query and Measure Items.
Parameters and Macros.
Model for Predictable Results
Modelling Star Schemas.
Identify Reporting traps.
Facts and Dimensions.
Implementing a Time dimension.
Creating Business Views
Create a Business View.
Populating the business view.
Dimensionally modelled relational data.
Determinants and Regular Dimensions.
Cognos Security Model.
Setting Security in the Cognos Namespace.
Package and Data Security.
Manage OLAP Sources
OLAP data source types.
Connect to an OLAP data source.
Publish an OLAP source.