IBM Cognos BI Framework Manager

IBM Cognos BI Framework Manager

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.

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...