Audience
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.
Prerequisites
There are no specific prerequisites for this course, however an understanding of Cognos BI would be greatly beneficial.
Duration
2 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
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
Course Content
Cognos Architecture
Cognos Connection.
Data Sources.
Reporting Packages.
Project Lifecycle.
Framework Manager Introduction
The Project Interface.
Naming Conventions.
Project Workflow.
Creating data sources.
Prepare Metadata.
Prepare Metadata
Query and Measure Items.
Creating Relationships.
Creating Calculations.
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.
Conformed Dimensions.
Dimensionally modelled relational data.
Determinants and Regular Dimensions.
Setting Security
Cognos Security Model.
Authentication Providers.
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.