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.

This course is intended for Modelers.

Introduction to IBM Cognos TM1

• Review financial performance management
• Discuss Online Analytical Processing (OLAP)
• Identify the TM1 position in the financial performance management system
• Describe the architecture and components of TM1
• Identify the basic tasks required to create a TM1 application 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

Load and Maintain Data

• Identify data sources
• Create processes to load data
• Create a process to delete data in a cube
• Create processes to update and maintain 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

• View related data
• Create a Drill Process
• Create a Drill Assignment Rule
• Edit a drill process

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
• Use TM1 techniques to reduce maintenance

Model for Different Fiscal Requirements

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

Contribute Data to Managed Planning Applications

• Examine Managed Planning Applications
• Explore user roles and built-in Workflow
• Use the TM1 Contributor Web grid

Create and Deploy Planning Applications to the Web

• Create a Managed Planning Application
• Manage Existing Applications
• Examine Design Techniques and Best Practices for Building Applications

Define Workflow (Optional)

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

Design for Reporting (Optional)