IBM Cognos TM1 Course Curriculum
You will be exposed to the complete IBM Cognos TM1 Trainingcourse details in the below sections.
Introduction and Installation
- Online Analytic Processing (OLAP)
- OLAP Data Structures Terminology
- OLAP Vs OLTP
- What is TM1
- TM1 Architecture
- Installing TM1 Server and Clients on a Machine
- Creating a new TM1 Data Server
- Running a TM1 Data Server
- Summary
Creating Dimensions in TM1
- Why Dimension is important in TM1 world.
- Creating Dimension manually
- Creating a sample Month dimension
- Adding additional levels in a dimension
- Adding Attributes in a dimension
- Using a TI Process (i.e. Script) to create the dimension
- Task for Practice
Loading and Maintaining Data
- Introduction
- Loading Data Manually in a view
- Loading Data using TI Process
- Clearing Data from a cube using a process
- Accumulating Data
- Saving Data
- Task for Practice
Adding Business Rules
- what are Rules in TM1
- Creating Simple Business Rules
- Creating a rule to share data between cubes
- Creating Picklist using a Rule
- Custom Calculation
- Task for Practice
Building Cubes and Views
- What are Cubes and Views in TM1
- Creating a cube manually and Via TI Process
- Creating a static Picklist
- Creating a Plan Cube
- Creating a Subset picklist
- Task for Practice
Optimizing Rules
- Rules and Feeders Importance and Impact
- Adding SkipCheck and Feeders
- Task for Practice
Automating Data load Processing using Scripts
- Introduction
- Loading data from Multiple Columns in a single column
- Creating dimension and a subset in TI process
- Exporting data to Ascii text using TI Process
- Task for Practice
Converting Currencies
- Introduction
- Creating Currency Dimension
- Creating a currency Cube
- populating currency attributes
- creating rules to apply exchange rates and calculate the amounts in Target Currency
- Task for Practice
Data Movement and Chores
- Moving Data Between versions
- Moving data using scripts and parameters
- Introduction of Chores
- Creating a scheduled Chore
- Task for Practice
Security
- Creating User and Groups in TM1
- Application Security
- Cube Security
- Dimension Security
- Element Security
- Task for Practice
Creating Reports
- Snapshots
- Slice
- Active Forms
- Task for Practice