RKSOFT IT TRAINING

IBM Cognos TM1(Table Manager one) is a very nice analytics engine. Tm1 is planning, budgeting, forecasting, analysis and score carding tool. 
We can create flexible and easy planning applications and also contains reporting capabilities.

​

Content:-

​

Module 1 – Introduction to IBM Cognos TM1

• Review financial performance management

• Describe the architecture and components of TM1

• Explain Severs and servic

​

Module 2 – Create Dimensions

 

• Review cubes and dimensions

• Create dimensions manually

• Edit dimensions

• Create dimensions using Turbo Integrator

• Work with Dimension Editor/Attributes

• Work with different elements C, N and S

​

Module 3 – Build Cubes and Views

 

• Discuss cubes and data points

• Create cubes

• Construct views of data in cubes

• Create and use a pick list

• Create Static subsets & Dynamic subsets

• Create Private, Public and Default Views

​

Module 4 – Load and Maintain Data Via Turbo Integrator (TI)

 

• Create processes to load data

• Create a process to delete data in a cube

• Create processes to update the model

• Schedule process /edit process

• Write script on Prolog, metadata, data and Epilog

• Create parameters

• Derive new variables by using formulas

​

Module 5 – 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

​

Module 6 – Optimize Rule Performance

 

• Optimize rule performance

• Use Skipcheck and Feeders

• Employ tools to enhance rules and feeders

​

Module 7 – 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

​

Module 8 – Customize Drill Paths & Data Spreading Methods

 

• Create a Drill Process

• Create a Drill Assignment Rule

• Data Spreading Methods

• Equally, replace and proportional

​

Module 9 – 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

​

Module 10 – Model for Different Fiscal Requirements

 

• Discuss time considerations

• Use discrete time dimensions

• Implement a continuous time dimension model

​

Module 11 – Introduction Security to Managing Applications

 

• Server level security

• Cube level Security

• Dimension level security

• Security Assignment for Individual Dimensions, Cubes

​

Module 12 –Create and Deploy Planning Applications to the Web Client

 

• Create a Managed Planning Application

• Apply security to Managed Planning Applications

• Examine design techniques and best practices

​

Module 14 –Project – Create and Deploy Planning Applications to the Prospects (Excel)

 

• Connect TM1 server in excel

• Create snapshot and Slicer

• Create & Manage Active Forms