Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


IBM Cognos TM1: Design and Develop Models (V9.5)

IBM Course Code: J0102G

GK# 9476 Vendor# P6502G

Course Overview


IBM Cognos TM1: Design and Develop Models (V9.5) is a five-day, self paced course designed to teach modelers how to build a complete model in TM1. Through hands-on exercises, students will learn how to set up and verify structures, manually enter data into these structures, and define the data users can see.

What You'll Learn



Viewing outline for:

Self-Paced Outline

Introduction to IBM Cognos TM1

  • Review financial performance management
  • Describe the architecture and components of TM1
  • Identify the basic tasks required to create a TM1 model and deploy it

Create Dimensions

  • Review cubes and dimensions
  • Create dimensions manually
  • Edit dimensions
  • Create dimensions using Turbo Integrator

Build Cubes and Views

  • Discuss cubes and data points
  • Create cubes
  • Construct views of data in cubes
  • Create and use a pick list

Load and Maintain Data

  • Create processes to load data
  • Create a process to delete data in a cube
  • Create processes to update the model

Add Business Rules

  • Discuss a rule
  • Construct rules for elements or consolidations
  • Use functions in rules
  • Optimize rule performance
  • Discuss rules in a Rule Worksheet

Optimize Rule Performance

  • Optimize rule performance
  • Use Skipcheck and Feeders
  • Employ tools to enhance rules and feeders

Transfer Data into Your Model Using Scripts

  • Review Advanced tabs in Turbo Integrator
  • Add a subset to a dimension
  • Use logic in scripts
  • Move data between versions
  • Construct chores

Customize Drill Paths

  • Create a Drill Process
  • Create a Drill Assignment Rule

Using Rules for Advanced Modeling

  • Discuss virtual cubes
  • List uses for lookup cubes
  • Create and use a spread profile cube
  • Implement moving balances in a cube

Convert Currencies

  • Discuss currency challenges
  • Create currency dimension
  • Create currency cube
  • Create rules for currency conversion

Model for Different Fiscal Requirements

  • Discuss time considerations
  • Use discrete time dimensions
  • Implement a continuous time dimension model

Introduction to Managed Planning Applications

  • Review the purposes and benefits of a managed planning application
  • Review supported platforms

Contribute Data to Managed Planning Applications

  • Access a Managed Planning Applications
  • Identify user roles and workflow states
  • Enter data using shortcuts and spreading
  • Submit and reject data

Create and Deploy Planning Applications to the Web

  • Create a Managed Planning Application
  • Apply security to Managed Planning Applications
  • Examine design techniques and best practices

Define Workflow (Optional)

Integrate with IBM Cognos 8 BI and IBM Cognos Planning (Optional)

Design for Reporting (Optional)

Who Should Attend


This intermediate course is intended for Modelers.

Course Delivery

This course is available in the following formats:


On-demand content enables you to train on your own schedule.

Request this course in a different delivery format.