IBM Cognos 11.0.7 - Framework Manager

Metadata Modeling Best Practices


Metadata Modeling Best Practices with IBM Cognos Framework Manager is a three-day, instructor-led, online course. This course ensures participants will become proficient with the Framework Manager modeling tool following a best practices approach.

This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student's computer screen and offer guidance. A full set of course materials is included and hard copies sent prior to the class.


Techniques learned in this course are relevant to all versions of IBM Cognos BI v10 and IBM Cognos Analytics v11. Read details about similarities and differences between Cognos v10.x and v11. 

Class Length

Three Days



Suggested Attendees

Modelers: Individuals creating metadata models (Relational and Dimensionally Modeled Relational)

Class Outline
  1. Become proficient with the Framework Manager modeling tool following a best practices approach
    1. Examine Cognos components and introduce metadata concepts
    2. Examine how report authors leverage the metadata model
    3. Discover best practices for modeling with Framework Manager
    4. Identify common “traps” and other modeling challenges
    5. Define cardinality, and examine how it is used by Cognos
    6. Understand and control the use of determinants
  2. Identify common data structures and modeling traps
  3. Create a project and prepare metadata
    1. Set properties to control query item behavior
    2. Establish a multi-tiered model design using namespaces
    3. Understand how cardinality and context impact query results
    4. Compare model query subjects and data source query subjects
  4. Learn to model for predictable results
    1. Examine SQL types and the Cognos Query Engine (CQE)
    2. Identify model design issues
    3. Examine SQL generation
    4. Merge query subjects and create a “dimensional” design
    5. Populate business view
    6. Enhance metadata with calculations, filters and parameterized SQL
    7. Review each query subject’s determinants and modify as required
    8. Create custom packages
    9. Apply package and object-level security
  5. Use a three-tiered design to organize metadata logically
  6. Create business-friendly views of data
  7. Use shortcuts and aliases to support role-playing dimensions, presentation objects and recursive hierarchies
  8. Secure metadata to allow appropriate access by users (row-level, object-level and package-level)
  9. Create and deploy custom packages for different audiences
  10. Understand how to leverage Dynamic Query Mode (DQM) in packages
  11. Examine project governors
  12. Dimensionally model relational content
    1. Create a dimensionally modeled relational model
    2. Create regular dimensions
    3. Define hierarchies
    4. Create a measures dimension
    5. Enable dynamic query mode
    6. Analyze publish impact on existing reports
    7. Create a model report
Registration Details

  • Senturus accepts payment by credit card, purchase order, and invoice.
  • Paying party will receive a payment confirmation email upon payment receipt.
  • Each registered participant will receive an email with the course confirmation and details on how to access the online classroom.
  • A full, hard copy set of course materials is shipped to each United States based student a few days prior to the start of class.
  • *International students will receive electronic copies of the course guide in place of a hard copy. These students may print one hard copy of the guide for their own personal use during the course. The course materials are copyrighted and any other reproduction or distribution of these materials is strictly prohibited.

We recommend that all attendees have two displays (monitors) so they can see the training presentation and their hands-on class work simultaneously.

Audio for attendees is via VoIP and a PC Headset is highly recommended. Audio is also available via teleconference using a TOLL number.

For this course, attendees will need to connect to the demonstration environment via Remote Desktop. Instructions will be provided in the registration confirmation.

Cancellations made ten or more calendar days prior to the first day of the course receive a 100% refund.

Cancellations made between five and nine calendar days prior to the first day of the course receive a 50% refund.

Registrants will be charged 100% of the enrollment fee if a cancellation request is not received at least five calendar days prior to the first day of the course.