IBM Cognos Transformer: Design OLAP Models

ExistBI is an IBM Cognos Partner

Course Description

This 4-day IBM Cognos Transformer training, Code: B5A82G, 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.

Course Summary

Next Public Course Dates

UK & Europe:

  • 24 - 27 November 2026
  • 26 - 29 January 2027
  • 23 - 26 February 2027

US & Canada:

  • 26 - 29 January 2027
  • 23 - 26 February 2027
  • 23 - 26 March 2027

More dates

Prerequisites
  • Understand the business need for ad hoc queries and analysis
  • Experience gathering requirements and analyzing data
  • IBM Cognos Report Studio: Author Professional Reports – Fundamentals (Recommended)
Duration
  • 4 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Developers who design OLAP models for use in IBM Cognos

Course Modules

  • Overview of IBM 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

Testimonials

“Instructor was very passionate about Databricks and helped me to stay engaged. Great pace, great knowledge, and the trainer was fantastic overall :) ”

★★★★★

- Emma Darling, Platform Engineer, Barclays Bank

“The SAP BOID10 Universe Designer class was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”

★★★★★

- Grahame Welch, Head of BI, UK Home Office

The training with Thomas went very well, and I felt the course overall was well balanced. Thomas was able to help with my many specific questions related to our internal project requirements, and he was helpful, clear, and concise throughout – 5 star /excellent!

★★★★★

- Marco, Lead Data Platform Engineer, C. Hoare & Co.

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    For a free assessment, quick quote or training information, send us a message

      To discuss your training requirements or book a class, drop us a line

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.