Cognos TM1 Online Training
Cognos TM1 Online Training Course Content
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
