COGNOS TM Online Training

Cognos TM1 – Green Sheet

 

COGNOS TM1 Developer Perspective

→ Examine TM1 Components

  • Understand how TM1 enables financial performance management
  • Understanding Profit Loss & Balance Sheet Statements
  • Identify the TM1 user community
  • Describe the components of TM1

→ Introduction to Data Warehousing

  • Introduction to OLAP
  • OLTP Vs OLAP
  • Types of OLAPs
  • Data Modeling
  • Dimensional Analysis

→ Introduction to IBM Cognos TM1

  • Introduction to Cognos TM1
  • Describe the TM1 Architecture
  • Describe the TM1 Components
  • Different TM1 User Interfaces and Clients

→ Discussing Installation

  • Pre-requisites to Install TM1
  • Installing TM1
  • Configuring TM1

→ Create TM1 Servers

  • Important Files in TM1
  • Creating Servers and configuring them
  • Logon to TM1 Server and browse sample data

→ Create Dimensions

  • Review cubes and dimensions
  • Discuss Dimension
  • Discuss Element
  • Types of Elements
  • Create dimensions manually
  • Edit dimensions
  • Using weights with elements

→ Customize Drill Paths

  • Create a Drill Process
  • Create a Drill Assignment Rule

→ Build Cubes and Views

  • Discuss cubes and data points
  • Create cubes
  • Construct views of data in cubes
  • Create and use a pick list
  • Discuss virtual cubes

→ Turbo Integrator

  • What is Turbo Integrator
  • Create dimensions using Turbo Integrator
  • Create cubes using Turbo Integrator
  • Using attributes

→ Load and Maintain Data

  • Create processes to load data
  • Create a process to delete data in a cube
  • Create processes to update the model

→ Add Business Rules

  • Discuss a rule
  • Construct rules for elements or consolidations
  • Use functions in rules
  • Optimize rule performance
  • Discuss rules in a Rule Worksheet

→ Optimize Rule Performance

  • Use Skip check and Feeders
  • Employ tools to enhance rules and feeders
  • Transfer Data into Your Model Using Scripts
  • Review Advanced tabs in Turbo Integrator
  • Add a subset to a dimension
  • Use logic in scripts
  • Move data between versions
  • Construct chores

→ Replication

  • What is Replication
  • Process of Replication
  • Handling Replications
  • Scheduling replications

→ Convert Currencies

  • Discuss currency challenges
  • Create currency dimension
  • Create currency cube
  • Create rules for currency conversion

→ Security

  • Creating users
  • Creating Groups
  • Examine diff type of access
  • Assigning access to users and groups

→ TM1 Best Practices

  • Functionality
  • Maintainability
  • Performance

COGNOS TM1 END USER Perspective

 

Data Exploration

→ What is Data Cube

  • Viewing Data in a Cube
  • Calculating a View
  • Arranging Dimensions

→ Spread Sheet Analysis

  • Create and Deploy Planning Applications to the Web
  • Create a Managed Planning Application
  • Apply security to Managed Planning Applications
  • Examine design techniques and best practices
  • Examine InSpreadsheet browser
  • Taking View Snapshots
  • Slicing a View
  • Spreadsheet Functions

→ Monitor Server Performance

  • Use TM1 log files
  • Dynamically monitor TM1 server threads
  • Broadcast messages to clients
  • Connect and disconnect users from a TM1 server
  • Shut down a remote TM1 server

→ Create cubes using Turbo Integrator

  • Using attributes
  • What is Turbo Integrator
  • Create dimensions using Turbo Integrator
  • Create cubes using Turbo Integrator
  • Using attribute Cont Build Cubes and Views

→ Turbo Integrator

  • What is Turbo Integrator
  • Create dimensions using Turbo Integrator
  • Turbo Integrator
  • What is Turbo Integrator
  • Create dimensions using Turbo Integrator
  • Create cubes using Turbo Integrator
  • Using attributes

→ Load and Maintain Data

  • Create processes to load data
  • Create a process to delete data in a cube
  • Create processes to update the model Create cubes using Turbo Integrator
  • Using attributes Turbo Integrator
  • What is Turbo Integrator
  • Create dimensions using Turbo Integrator
  • Create cubes using Turbo Integrator
  • Using attributes Discuss cubes and data points
  • Create cubes
  • Construct views of data in cubes
  • Create and use a pick list
Online Courses Videos