IBM Cognos Transformer

    

Summary:
This class is designed to engage the students and promote long term retention. It does so by mimicking real world environment. It is project based; discovery driven, collaborative and adaptive to an individual's learning preference. Students learn through hands-on exploration under the guidance of an experienced instructor who brings the wealth of real world experience to the classroom.

Duration:
4 Days/Lecture & Lab

Audience:
This class is designed with cube modelers in mind. If you have experience with OLAP and dimensional modeling then this class is for you.

Topics:

• Introduction to Cognos 8 BI
• What is Transformer?
• How is Transformer different in Series 7 and Cognos 8 BI
• Parts of Transformer
• Who, What, Where, When - Dimensions
• How much & How Many - Measures
• Categories & Members
• Dimensional design in Transformer
• Multi-query models and why you use them
• Date Dimensions & Relative Time Categories
• Uniqueness
• Allocation
• Advanced Modeling Techniques
• Multiple Cubes from the same model
• Performance
• Maintenance
• Tie in to security

Prerequisites:
-Knowledge of OLAP concepts and an understanding of Cognos 8 BI-Knowledge of SQL and Data Warehousing is a plus

Last Update: May 21, 2012