IBM Cognos TM1 9.4: Designing and Developing Applications SPVC

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

Present Data and Reports

• Organize content in TM1 using application folders
• Use Action buttons to enhance functionality in Excel and TM1 Web reports
• Add worksheet controls to change the presentation of data

Define Workflow

• Configure TM1 for Workflow
• Install Workflow
• Create Workflow versions
• Use Workflow toolbars to review versions

A: Introduction to Executive Viewer

• Repeat the steps to start the TM1 server and start the Executive Viewer client to employ Executive Viewer functionality
• Locate data by connecting to a data source
• Create a view to analyze your data
• Organize members and dimensions within a view

B: Integrate with IBM Cognos 8 BI and IBM Cognos 8 Planning

• Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
• Integrate IBM Cognos TM1 in Cognos 8 BI portals
• Describe how to use TM1 data in an IBM Cognos 8 Planning application
• Describe how to use IBM Cognos 8 Planning data in a TM1 application