IBM Cognos Transformer: Design OLAP Models (v10.2.2)

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.


  • Discover how to manage, secure, and troubleshoot wireless network elements
  • Understand how wireless technologies work and how to integrate them into existing networks
  • Learn about wireless local loops, wireless LANs, mobile IP operations and design, and cellular IP
  • Evaluate the differences between CDMA, TDMA, and GSM and the implications for your network
  • Learn how Bluetooth and PLANs can affect your network
  • Explore wireless applications for m-commerce, inventory tracking, and smart offices
  • Save money and make your network more flexible
  • The protocols of converging analog and digital wireless systems, including data over packet radio and SMR/ESMR
  • Wireless networking including electromagnetism, air interfaces, and radio transmission technologies
  • The hot new wireless LAN technology Bluetooth
  • The network structure and types of wireless local loops
  • Applications driving wireless network implementation
  • Mobile IP operations, registration, tunneling, routing, design, QoS, management, and testing
  • Wireless voice/video over IP
  • Mobile IP routing for 3G

Target Audience

Developers who design OLAP models for use in IBM Cognos B


Expected Duration

4 day

Course Objectives

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
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