IBM Cognos Report Studio Multidimensional Reporting

    

Summary:
This course 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:
2 Days/Lecture & Lab

Audience:
This class is designed with report authors that use dimensional packages in mind. If you have experience withReport Studio and dimensional modeling then this class is for you.

Topics:

• Difference between dimensional and relational packages
• MDX functions in Cognos
• Creating reports from hierarchies
• Filtering
• Calculated measures and Calculated members
• Aggregation
• Drilling and Member sets
• Additional prompt available for DMR
• Categories & Members

Prerequisites:
-Knowledge of reporting and an understanding of Cognos 8 BI -Hands-on knowledge of Report Studio-Knowledge of SQL and Data Warehousing is a plus

Last Update: May 22, 2013