Fundamentals of Cognos TM1

Cognos Training Course outline

Cognos TM1 Architecture

INTRODUCTION TO IBM COGNOS TM1

TM1 Components

  • Tm1 architect
  • Tm1 perspectives
  • Tm1 turbo integrator
  • Tm1 Cube Viewer
  • Tm1 Subset Editor
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

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

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy