Courses

Cognos TM1-10 Course Curriculum

INTRODUCTION TO IBM COGNOS TM1 10
Difference between Tm1 9.X and Tm1
Cognos TM1-10 Architecture

TM1 Components

  • Tm1 architect
  • Tm1 perspectives
  • Tm1 turbo integrator
  • Tm1 Cube Viewer
  • Tm1 Subset Editor

How to Create New TM1 server and configure Server

Cognos Performance Modeler

  • About Performance Modeler
  • Types of Dimension in Performance Modeler
  • How to create Dimensions manually
  • How to Create Measure Dimension
  • How to Create Time Dimension
  • How to Populate Time Dimension
  • How to Create Hierarchy Dimension
  • How to Add Attribute to Dimension
  • How to Create Pick List
  • How to Create Dimension using process
  • How to create Calculated Column
  • How to Create Cube
  • How to load data into Cube
  • How to Link Cubes
  • Types of access permissions in Performance Modeler
  • Levels of access permissions in Performance Modeler
  • How to provide access permissions in Performance Modeler
  • How to Create Users and User Groups in Performance Modeler
  • How to add users to User Groups in Performance Modeler
  • How to assign capabilities to user Groups
  • Types of Applications in Performance Modeler
  • How to create application in Performance Modeler
  • How to validate application
  • How to publish application
  • How to provide Rights to application
  • How to Import Rights
  • How to Export Application
  • How to Import Application

Cognos Insight

  • About Cognos Insight
  • How to Create Model Using Dreage and drop
  • How to create Model Using XL as Data source
  • How to TM1 As data source
  • How to User Database As Data Source
  • How to create Calculate columns
  • How to edit data in Insight for Tm1 Cubes
  • How to Create Custom Groups
  • How to export Data into Ex
  • How to add Exported XL into Tm1 Applications
  • How to update in insight and export into Excel
  • How to create applications
  • How to Publish application
  • How to activate application
  • How use action button in Insight

 

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
  • How to create inspreadsheet browser
  • How to create More then one inspreadsheet browser and compare Data
  • How to Create Subset from inspreadsheet browser
  • How to create Cube View from inspreadsheet browser
  • How to restrict Write access for worksheet in Tm1 Web

How to create Template

  • How to Run Process using template
  • How to pass value from XL to Process


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

Tm1 operations console

About operations console
How to add Server to operations console

live Chat