Kurs informasjon: 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

Roadmaps:

• 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

Til top

This course is intended for Modelers

Til top

• IBM Cognos TM1: Analyze Data (V9.5)
• Basic knowledge of OLAP and TM1
• Significant experience with Excel spreadsheets (functions, macros, etc.)
• Understanding of the metrics and drivers of your business

Til top

Please refer to course overview for description information.

Til 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)

Til top