Cognos TM1 Training Course

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
How to Setup a TM1 Server to run as windows services

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

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
  • Use Subset in Cube

Creation of Cube View

  • Private View
  • Public View
  • Default View

Creation Of filter

  • Filter by Level
  • Filter by attribute

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

Worksheet Functions

  • DBRW

Create Slice report Using Function

Drill Through

  • Drill through to cube view

Adding Business Rules
Writing business Rules
Controlling calculations
Adding business logic to rules

Data Spreading and hold values
MANAGE THE SERVER

  • 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

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