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

IBM Cognos TM1: Design and Develop Models (V9.5) is a five-day, instructor-led course designed to teach modelers how to build a complete model in TM1. Through a series of lectures and 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.

View this course in other countries

Training Paths that reference this course are:

• IBM Cognos TM1 9.5 –Administrator Role
• IBM Cognos Business Viewpoint 10.1 – Modeler & Administrator Role
• IBM Cognos TM1 9.5 – Modeler Role
• IBM Business Viewpoint 10.1 - Administrator
• IBM Business Viewpoint 10.1 - Modeler

Back to top

IBM Education Advantage Program Eligibility

• Yes - IBM Education Pack - Online account

Back to top

This intermediate course is intended for Modelers

Back to top

You should have taken:

• IBM Cognos TM1: Analyze Data (V9.5)

You should have:

• Basic knowledge of OLAP and TM1
• Significant experience with Excel spreadsheets (functions, macros, etc.)
• Understanding of the metrics and drivers of your business

Back to top

Please refer to course overview for description information.

Back to top

Introduction to IBM Cognos TM1

• Review financial performance management
• Describe the architecture and components of TM1

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)

Optimize and Tune TM1 Models (Optional)

Identify Common Data Structures (Optional)

Back to top