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:

  • 25 - 28 August 2026
  • 22 - 25 September 2026
  • 27 - 30 October 2026

US & Canada:

  • 25 - 28 August 2026
  • 22 - 25 September 2026
  • 27 - 30 October 2026

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

“The BOW310/320 Web Intelligence Bootcamp was very good.  The experienced and friendly trainer was very patient with all our questions and made sure we completed each exercise correctly. The post class support was also excellent!”

★★★★★

- Kelly Delaberta, BI Data Analyst, US Air Force

“Our Informatica Axon and Enterprise Data Catalog training classes were all excellent for our needs.  The trainer really knew a lot about data governance strategy, frameworks, stewardship and actual implementation. As a senior consultant, he had implemented many projects, this really helped in Q&A. Highly recommended.”

★★★★★

- Susan Charles, IT Director, SoFi Bank

“Mahesh was an EXCELLENT trainer. Very gifted instructor. Able to clearly communicate and teach objectives. Very engaging made you want to keep learning, and was so patient and kind to all students. Would love to be taught by him anytime.

★★★★★

- Jackie Calvo, Quality Improvement Manager, Horizon Health Center

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    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.