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

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)