IBM Cognos 10 Creating Data Models with Transformer

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.

Goals
  1. Understand Transformer’s role in modeling.
  2. Design a dimension map and model based on business rules.
  3. Import data source in a model.
  4. Create a dimension map and measures.
  5. Define and resolve uniqueness.
  6. Build a date dimension and add relative time categories.
  7. Allocate measures.
  8. Create alternate drill paths.
  9. Build and publish cubes and sub cubes.
  10. Maintain models and cubes.
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.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

I really enjoyed taking this course and would recommend it to anyone who wants to know how to use FrameMaker.
Mary Pat Thoma
Draeger Safety
I'm now advanced in Microsoft Project within 2 days!
Suzanne Hill
PFM Medical, Inc.
The Advanced Microsoft PowerPoint Training exceeded my expectations. The instructor moved the class along at a good pace, yet paused when there were questions. Will definitely recommend this course to my colleagues.
Marta Feilen
New Avon
I would definitely take classes through Webucator in the future. It was an enjoyable and relevant learning experience.
Stephanie Hawtof
n/a

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

62,336

Students who have taken Instructor-led Training

11,816

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,186 reviews

Contact Us or call 1-877-932-8228