Description

The Framework Manager course provides participants with knowledge on how to model metadata with Framework Manager using Cognos modeling recommendations as a modeling strategy. Initially, participants will review generic modeling structures and techniques as a foundation for the rest of the course. They will then be introduced to basic modeling concepts and naming conventions in the Framework Manager environment, followed by more complex concepts and techniques to resolve reporting traps. Throughout the course, participants will model both operational and star schema metadata for predictable results, as well as create a dimensional model to be used for dimensional style querying.

Duration

Two days

Audience

This course is for data modelers.

Overview of Topics

• Overview of the Cognos environment

• Metadata modeling best practices

• Setting up relationships

• Query engine treatment of query subject cardinality

• Common modeling traps and how to handle them

• Enhancing the model

• Dimensional modeling

• Specifying determinants to insure proper aggregation

• SQL types

• Security in Framework Manager

• Advanced capabilities of Framework Manager (optional)

Prerequisites

• Knowledge of SQL and data modeling

• Experience with relational management systems (RDBMS)