About this course

Course code TPZL1_B5282
Duration 4 Days

IBM Cognos Transformer: Design OLAP Models (V10.2) is a four-day course that provides developers with knowledge of OLAP modeling concepts using 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.

Prerequisites

This offering is intended for:

  • Developers who understand the business need for ad hoc queries and analysis, and have experience gathering requirements and analyzing data.

It is also recommended that students take:

  • the IBM Cognos Report Studio: Author Professional Reports Fundamentals (V10.2) course.

Who Should Attend?

This intermediate course is for Developers who design OLAP models for use in IBM Cognos BI.

Outline

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 IBM Cognos Security

Applying Security

Maintain Models and PowerCubes

Considerations for Drill Through

Optimize PowerCubes

Partition PowerCubes

Blank Model Plans (Optional)

Identify Common Data Structures (Optional)

4 Days

Duration
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.