Training offering

IBM Cognos TM1: Designing and Developing Applications (Version 9.4)

Description

IBM Cognos TM1: Designing and Developing Applications is a five-day, instructor-led course designed to teach application developers, typically business or financial people, how to set up a complete TM1 application. 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.

Participants

This course is intended for Application Developers.

Prerequisite(s)

Basic knowledge of OLAP and TM1 Significant experience with Excel spreadsheets (functions, macros, etc.) Understanding of the metrics and drivers of their own business IBM Cognos TM1 9.4: Analyzing Data (recommended)

Programme

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
Automate Common Processes Using Scripts
•    Review Advanced tabs in Turbo Integrator
•    Load custom data into a cube
•    Add a subset to a dimension
•    Use logic in scripts
•    Export data to ASCII
•    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

Options

Roadmaps that reference this course are:

•    IBM Cognos TM1 9.4 - Application Developer Role
•    IBM Cognos Express 9.0 / 9.5 – Administrator Role
•    IBM Business Viewpoint 10.1 - Modeler
•    IBM Business Viewpoint 10.1 - Administrator