This two day course is designed for advanced Framework Manager Modelers. Topics such as SQL generation, optimizing and tuning projects, as well as more advanced topics such as leveraging parameters and macro functions will provide your IT staff with the knowledge necessary to build both flexible and optimized metadata models.

Course Outline

This two-day instructor-led metadata modeling course is best suited to professional metadata modelers.
During the session, students will dive into the more obscure Framework Manager lifecycle options and considerations.

Each topic will be highlighted with in-depth workshops, question and answer sessions and tips and techniques drawn from years of cross industry experience.

Pre-requisites

A good comprehension of Microsoft Windows and the Office suite is mandatory.
Prior IBM Cognos 10 Framework Manager knowledge is required.

High-level Curriculum

  • Query generation architecture overview
  • Cognos SQL vs. Native SQL
  • Aggregation rules
  • Multi-fact/multi-grain queries
  • Common data trap overview
  • Leveraging session and custom parameters
  • Use of macros
  • Extra Features