IBM Cognos 10 Creating Data Models with Transformer

IBM Cognos 10 Creating Data Models with Transformer

Course Length:
Delivery Methods:   Available for private class only
Course Topics
  •  Understand Transformer’s role in modeling.
  •  Design a dimension map and model based on business rules.
  •  Import data source in a model.
  •  Create a dimension map and measures.
  •  Define and resolve uniqueness.
  •  Build a date dimension and add relative time categories.
  •  Allocate measures.
  •  Create alternate drill paths.
  •  Build and publish cubes and sub cubes.
  •  Maintain models and cubes.
Course Overview

This IBM Cognos 10 Creating Data Models with Transformer training class introduces data modeling techniques with IBM Cognos’ Transformer. Topics include IBM Cognos overview, planning and designing models, creating data sources for Transformer, creating single query and multi-query models, building dimension maps and measures, designing advanced dimensions, building multi-cube models and more. The course format includes lecture, instructor-led exercises and independent workshops.

This course is for developers and other users, who will create, maintain, and build models and cubes using Transformer.

Course Outline
  1. Overview of IBM Cognos 10
    1. Overview of IBM Cognos 10
    2. Overview of Studios
    3. New Studios and Features in IBM Cognos 10
  2. Overview of Cubes, Models and Transformer
    1. Define Cubes and Dimensional Models
    2. Define Dimensions and Measures
    3. Understand the Differences between Dimensional Models and Cubes
    4. Introduce Framework Manager and Transformer
  3. Planning Your Model
    1. Define Models
    2. Introduce Dimension Maps
    3. Create a Model Plan
  4. Create a Simple Transformer Model
    1. Introduce the Transformer Interface
    2. Build and Compare Data Sources
    3. Single and Multi-Query Models
    4. Understand Model Formats
  5. Create Dimensions
    1. Create a Dimension Map
    2. Understand Levels, Categories and their Properties
    3. Generate Categories and View Dimension Diagrams
  6. Measures
    1. Define Measures Types
    2. Create Regular and Calculated Measures
    3. Understand Measure Properties
    4. Define and Use Measure Rollups
    5. Allocate Measures
  7. Time and Relative Time
    1. Use the Date Wizard
    2. Models with Multiple Date Dimensions
    3. Set the Current Period
    4. Create Relative Time Categories
  8. Advanced Dimensions
    1. Create Alternate Drill Paths
    2. Understand Convergence Levels
    3. Build Subdimensions
  9. Build and Deploy Cubes
    1. Build a Cube
    2. Build Multiple Cubes in the Same Model
    3. Cube Groups
    4. Dimension Views
    5. Exclude Measures
    6. Understand Packages and Data Sources
    7. Deploy Cubes
    8. Understand Partitions
  10. Custom Views and Security
    1. Introduce Custom Views
    2. Understand Model and Cube Security
  11. Model Maintenance
    1. Evaluate Model Changes
    2. Update Cubes with Scripts
    3. Incremental Updates
  12. Summary
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Cognos class:

  • A basic knowledge of IBM Cognos 10, IBM Cognos 10 Analysis Studio or PowerPlay Studio, Windows, Internet Explorer, and browser techniques is recommended.
  Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing