Description

IBM Cognos Transformer is metadata modeling software for creating PowerCubes for data analysis with IBM Cognos BI. This course will introduce you to the concepts related to OLAP cube modeling and the tasks to design and deploy PowerCubes created with Transformer.

Who is this training for ?

For whom ?

OLAP model developer analysts, project management assistants.

Prerequisites

Training objectives

Navigating the Transformer interface Define a data model Structuring navigation paths in a multidimensional model (cube) Create performance indicator (KPI) calculations Manage integrity, security, and publish the cube

Training program

• Introduction
  • Introduction to the IBM company.
  • Introduction to the Cognos 10 BI suite.
  • Introduction to the features of the Transform tool in the Cognos 10 BI suite.
  • Introduction to the role of the Transform tool in the Cognos 10 BI suite.
• Concepts and implementation
  • Presentation of the interface.
  • Getting started with the environment.
  • Multidimensional analysis.
  • Definition of a data model.
  • Notions of members, dimensions and measures.
  • The different stages of creating the cube.
  • Exercise: Practical cases understanding a simple data model.
• Structuring data in Transformer
  • The different types of data sources.
  • Managing connections.
  • Defining column properties and sources.
  • The creation of Single Sign On.
  • Creation of the model in automatic or manual mode.
  • Creation of dimensions and calculated columns.
  • Management of branches level and drill down paths.
  • Management of the time dimension.
  • Category management.
  • Integrity control and generation of Powercubes.
  • Exercise: Practical cases for creating simple cubes.
• Model KPIs (Key Performance Indicators)
  • Creating regular measures.
  • Creating calculated measures.
  • Calculation functions in Transformer.
  • Rollup functions regular or external.
  • The different notions of consolidation.
  • Managing the breakdown of measures.
  • Exercise: Practical cases of creating measures and calculations.
• Security and publishing
  • Creating user groups and users in Cognos Connection.
  • Creating and managing user roles.
  • Managing security in cubes.
  • Creating custom views.
  • Creating passwords for Powercubes.
  • Publishing Powercubes.
  • Exercise: Practical cases for setting up and applying security.
• Conclusion
  • What to remember? Best practices for using the Transform tool.