BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Cognos TM1 Online Training

Cognos TM1 Online Training

sub-banner960x200

Cognos TM1 Online Training Course Topics

 

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