Online Training on IBM Cognos TM1 9.5

TM1 Development

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





Analysis using TM1

Examine TM1 Components

Review financial performance management

Understand how TM1 enables financial performance management

Identify the TM1 user community

Describe the components of TM1

Browse Data in a Cube

Understand what solution a model represents

List the components of a cube

Create a new view of the data

Stack, swap and filter dimensions in a cube

Use drill capabilities to focus the data

Focus Your Analysis using Subsets

Examine the benefits of subsets

Use aliases in subsets

Filter subsets

Differentiate between static subsets and dynamic subsets

Add user-defined consolidations in subsets

Contribute Data

Spread data to multiple cells at once

Edit individual cells

Exclude cells from being adjusted

Describe the power of lookup cubes

Work with Spreadsheets

Differentiate between a slice and a snapshot

Use a classic slice and an Active Form

Manage TM1 data through Excel

Use TM1 worksheet functions

Create Dynamic Reports with Active Forms

Create interactive reports and data input templates using Active Forms

Customize Active Forms using new TM1 Functions

Apply formatting to Active Forms

Organize and Distribute Results

Use TM1 applications to organize reports

Publish content to the Web

Access content using TM1 Web

Present Data Using TM1 Web

View and manipulate a TM1 Web Sheet

Stack and swap dimensions in a cube view

Create a new cube view

Graph data in a cube view

Use drill capabilities to focus the data

Print and save cube view as an Excel file or PDF

Edit Subsets in TM1 Web

Build a simple and complex subsets in TM1 Web

Create custom consolidations in TM1 Web

Appendix A: Enhance Report Presentation

Use Action buttons to enhance functionality in Excel and TM1 Web reports

Add worksheet controls to change the presentation of data

Appendix B: 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

Appendix C: Integrate with Cognos 8 Business Intelligence and Cognos 8 Planning

Describe how to use 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


SAND BOXES
CONTRIBUTOR