Font size:

This course provides developers with knowledge of OLAP modeling concepts using IBM Cognos Transformer. Participants will learn how to design, build, and maintain PowerCubes for use in IBM Cognos BI so that end users can easily analyze data.

  • Overview of IMB Cognos BI
  • Transformer Fundamentals
  • The Transformer Development Process
  • Data Sources in Transformer
  • Building a Model
  • Considerations for Designing Successful PowerCubes
  • The Time Dimension
  • Relative Time
  • Use Multiple Data Sources
  • Uniqueness
  • Working with Measures
  • Allocated Measures
  • Currency Conversion
  • Alternate Hierarchies within a Dimension
  • Advanced Dimensional Modeling
  • Customize Cube Content
  • Examine Security
  • Appling Security
  • Maintain Models and PowerCubes
  • Considerations for Drill Through
  • Optimize PowerCubes
  • Partition PowerCubes
  • Identify Common Data Structures

  • An understanding of the business need for ad hoc queries and analysis
  • Experience gathering requirements and analyzing data


Developers who design OLAP models for use in IBM Cognos Business Intelligence.

  1. Overview of IMB Cognos BI
  2. �Transformer Fundamentals
  3. �The Transformer Development Process
  4. �Data Sources in Transformer
  5. �Building a Model
  6. �Considerations for Designing Successful PowerCubes
  7. �The Time Dimension
  8. �Relative Time
  9. �Use Multiple Data Sources
  10. �Uniqueness
  11. �Working with Measures
  12. �Allocated Measures
  13. �Currency Conversion
  14. �Alternate Hierarchies within a Dimension
  15. �Advanced Dimensional Modeling
  16. �Customize Cube Content
  17. �Examine Security
  18. �Appling Security
  19. �Maintain Models and PowerCubes
  20. �Considerations for Drill Through
  21. �Optimize PowerCubes
  22. �Partition PowerCubes
  23. �Identify Common Data Structures

The course you have selected has limited or no upcoming scheduled training dates!

Please browse similar courses or request more information for assistance.'s training support team will respond within one business day with relevant offerings.