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

PLEASE DO NOT MAKE TRAVEL ARRANGEMENT FOR THIS SELF PACED VIRTUAL COURSE (SPVC). ONCE YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT.

After you receive confirmation that you are enrolled, you will be sent further instructions to access your course material and remote labs. You will then have a 30 day window in which to complete your course. Within this 30 days, you will have 336 hours of elab time. The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but lab system access is allocated on a first-come, first-served basis. When you are not using the elab system, ensure that you suspend your elab to maximize your hours available to use the elab system. Once you have accessed the course, help is available Monday through Friday; questions will be responded to within 24 hours.

NO EXTENSIONS FOR THIS COURSE WILL BE GRANTED.

This is the self paced training version of classroom course "IBM Cognos TM1: Design and Develop Models (V9.5)". 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.

View this course in other countries

Roadmaps that contain this course are:

• IBM Cognos TM1 9.5 – Modeler Role

Back to top

This intermediate course is intended for Modelers.

Back to top

You should have:

• 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

Back to top

Please refer to course overview.

Back to top

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)

Back to top

Minimum Requirements (for PC) to use SPVC

• Windows 2000, XP, Vista, and 7
• Firefox, including V3.6.6
• Internet Explorer, including V8
• browser settings include:
  • Java Runtime Environment must be installed and enabled in the web browser
  • Web browser must be set to enable/allow JavaScript
  • Web browser Pop-up blocking mechanisms must be set to allow pop-ups from elearn.ihost.com
  • Cookies must be enabled
  • Flash-enabled

• CITRIX, for the remote lab (instructions to install included with the SPVC)

Back to top