Contact us on +91 85198 83871 (44) 07448456791 or info@globaltnc.com

Cognos TM1 Online Training

Cognos TM1 Online Training

Course Duration : 30 Hrs

IBM Cognos TM1 is an enterprise planning software platform that can transform your entire planning cycle, from target setting and budgeting to reporting, scorecarding, analysis and forecasting. Cognos TM1 is readily adaptable for high levels of participation. Cognos TM1 provides integrated scorecards and strategy management capabilities which helps you to monitor performance metrics and align resources and initiatives with corporate objectives and market events. These advanced capabilities help companies become highly collaborative and adaptive. Cognos TM1 is readily adaptable for high levels of participation.

Cognos TM1 Course Content

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
  • 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

Worksheet Functions

  • DBR
  • DBRW
  • SUBNM
  • VIEW

Create Slice report Using Function

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

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

Request for Training

    OR