Cognos TM1 Online Training

Home / Cognos TM1 Online Training

Cognos TM1 Online Training Course 

Duration: 4-5 Weeks

Cognos TM1 Architecture
 Introduction to IBM COGNOS TM1
 TM1 Components
  • Tm1 architect
  • Tm1 perspectives
  • Tm1 turbo integrator
  • Tm1 Cube Viewer
  • Tm1 Subset Editor
 How to Create New TM1 server  and configure Server
 Create Elements
  • Types of Elements
  • Simple
  • String
  • Consolidated
  • Creation of elements
  • Editing Elements
  • Adding alias attributes to elements
  • Using alias attribute in Cube viewer
 Creation of Dimension
  • Creation of dimension manually
  • Creation of dimension using TI process
  • Creation of dimension using Dimension worksheet
  • Creating dimension using CSV as Data source
  • Creating dimension using Database as Data source
  • Creating dimension using subset as data source
  • creating more then one dimension from one data source
  • creating Alias attributes using Alias process
  • adding alias attribute for existing dimension using TI process
Creation of Cube manually
Creating of Cube using TI process
Loading data into Cube
Updating data in Cube
 Creation of Subset
  • Creation Of Subset
  • How to create public subset
  • How to create private subset
  • How to create default subset
  • How to create dynamic subset
  • Use Subset in Cube
Creation of Cube View
  • Private View
  • Public View
  • Default View
 Creation Of filter
  • Filter by Level
  • Filter by Wildcard
  • Filter by attribute
  • Data Filter Creation
 Working with Sandboxes
  • Creation of sandboxes
  • Deleting sandboxes
  • Commit Sandboxes
  • Reset data
 Work with Spreadsheets
  • Creation of Slice
  • Creation of snapshot
  • Creation of Active from
  • Active from vs snapshot
  • snapshot vs slice
 Working with Worksheet Slice and active form
  • Adding Action Buttons in worksheet
 In Spreadsheet Browser 
  • How to Create In Spreadsheet Browser
  • How to swap row and columns 
Worksheet Functions
  • DBR
  • DBRW
  • SUBNM
  • VIEW 
Create Slice report Using Function 
Pick List
  • How to create Static Pick List
  • How to create Subset Pick List
  • How to create Dimension Pick List 
WORKSHEET CONTROLS
  • Data Validation 
FORMAT AND PRINT RESULTS
  • How to print report in single work book
  • How to print report in multiple work books
Drill Through
  • Drill through to cube view
  • Drill through to Data Source(using ODBC) 
Adding Business Rules
Writing business Rules
Controlling calculations
Adding business logic to rules 
Data Spreading and hold values
MANAGE THE SERVER
  • BROADCAST MESSAGES TO CLIENTS
  • DISCONNECT CLIENTS FROM THE TM1 SERVER
  • SHUT DOWN REMOTE TM1 SERVERS
REPLICATE AND SYNCHRONIZE SERVERS
  • Replicate Cubes: Overview
  • Replicate Cubes: Advantages
  • Remove Replications
  • Synchronization
  • Schedule synchronization
  • Delete Replicate
About Log
  • ADMIN SERVER LOG
  • TRANSACTION LOG
  • SERVER MESSAGE LOG
  • AUDIT LOG
Deleting data in cube
Integrate with IBM Cognos 10 BI
  • Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
  • Integrate IBM Cognos TM1 in Cognos 8 BI portal
  • Importing Cognos Tm1 Cube into Cognos 8 Bi Environment
TM1 WEB 
  • About TM1 Web
  • Components in TM1 Web
  • How to create Cube view in TM1 web
  • How to use subset in Tm1 web
  • How to create Chart Report
  • How to change Chart Type and Colors
  • How to Change Chart appearance
  • How to Change Chart Properties
  • How to Run Process in Cognos TM1 Web
  • How to Edit Chores
  • How to Activate Chores
  • How to Execute Chores
  • How to change user password
  • How to change Dimension Properties
  • How to create Sandbox
  • How to commit Sand box
  • How to reload sandbox
  • How to delete sandbox
How to integrate TM1 Web with Cognos BI Portal 
Tm1 Security
  • Manually adding users to Server
  • Adding users to user groups using TI process
  • Creation of groups
  • Apply Security to cubes
  • Apply security to Dimensions
  • Apply security to Elements
  • cell level security
  • Locking Objects
  • Reserve objects 
How to integrate NTLM with Cognos TM1
How to use cognos BI packages as data source for cognos Tm1