ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
Cynosure Knowledge Solutions
                         Pl email me at masood@cynosureks.com

Cognos 9.5 TM1 DEVELOPMENT

Introduction to IBM Cognos TM1
Examine TM1 Components
Review financial performance management
Identify the TM1 user community
Describe the components of TM1


Understand TM1 Architecture
Define TM1 Architecture
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

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

Build Cubes and Views
Discuss cubes and data points
Create cubes
Construct views of data in cubes
Create and use a pick list

Load and Maintain Data
Create processes to load data
Determine the Data Source
Review the Data Structure

Website:www.cynosureks.com            Email:masood@cynosureks.com   Page 1
Cynosure Knowledge Solutions
                          Pl email me at masood@cynosureks.com
Import Data from an ASCII File
Use formulas in Variables
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
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

Customize Drill Paths
Create a Drill Process
Create a Drill Assignment Rule

Using Rules for Advanced Modeling
Discuss virtual cubes
List uses for lookup cubes
Create and use a spread profile cube
Implement moving balances in a cube

Convert Currencies
Discuss currency challenges
Create currency dimension
Create currency cube
Create rules for currency conversion

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




Website:www.cynosureks.com              Email:masood@cynosureks.com   Page 2
Cynosure Knowledge Solutions
                         Pl email me at masood@cynosureks.com
Create a Drill Process
Create a Drill Assignment Rule
Edit a drill process

Integrate with IBM Cognos 8 BI
Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
Integrate IBM Cognos TM1 in Cognos 8 BI portals


Present Data and Reports
Organize content in TM1 using application folders
Use Action buttons to enhance functionality in Excel and TM1 Web reports
Add worksheet controls to change the Presentation of data

Integrate with Cognos BI
Benefits of IBM Cognos Integration
Integrate IBM Cognos with IBM TM1

COGNOS TM1 END USER ANALYSIS
Data Exploration

What is Data Cube
Viewing Data in a Cube
Calculating a View
Arranging Dimensions

Spread Sheet Analysis
Examine InSpreadsheet browser
Taking View Snapshots
Slicing a View
Spreadsheet Functions

Organize and Distribute Results
Use TM1 Web
COGNOS TM1 ADMINISTRATION

TM1 Architecture and Installation
Describe the IBM Cognos performance management (PM) system and TM1's role in PM
Identify the components of TM1 architecture
Install TM1 components
Configure the TM1 serves

Replicate and Synchronize Servers
Describe the replication process
Identify replication relationships
Identify possible server configurations

Website:www.cynosureks.com                Email:masood@cynosureks.com          Page 3
Cynosure Knowledge Solutions
                         Pl email me at masood@cynosureks.com
Replicate cubes
Remove cube replications
Synchronize replications

Monitor Server Performance
Use TM1 log files
Monitor performance with control cubes
Dynamically monitor TM1 server threads
Monitor TM1 server performance in real time

Manage the Server
Broadcast messages to clients
Connect and disconnect users from a TM1 server
Shut down a remote TM1 server

Implement TM1 Security
Identify TM1 authentication options
Create users and groups
Configure integrated login
Assign object security rights to groups
Use rules to maintain security rights
Use Turbo Integrator processes to maintain security

Back Up and Recover Applications
Create processes to back up data
Plan for backup and recovery of TM1 applications

Migrate Applications from Development to Production
Document objects in the TM1 Application
Manage the application metadata




Website:www.cynosureks.com             Email:masood@cynosureks.com   Page 4

More Related Content

Cognos tm1 Training|cognos tm1 online training|100%Practical Training

  • 1. Cynosure Knowledge Solutions Pl email me at masood@cynosureks.com Cognos 9.5 TM1 DEVELOPMENT Introduction to IBM Cognos TM1 Examine TM1 Components Review financial performance management Identify the TM1 user community Describe the components of TM1 Understand TM1 Architecture Define TM1 Architecture 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 Turbo Integrator What is Turbo Integrator Create dimensions using Turbo Integrator Create cubes using Turbo Integrator Using attributes Build Cubes and Views Discuss cubes and data points Create cubes Construct views of data in cubes Create and use a pick list Load and Maintain Data Create processes to load data Determine the Data Source Review the Data Structure Website:www.cynosureks.com Email:masood@cynosureks.com Page 1
  • 2. Cynosure Knowledge Solutions Pl email me at masood@cynosureks.com Import Data from an ASCII File Use formulas in Variables 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 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 Customize Drill Paths Create a Drill Process Create a Drill Assignment Rule Using Rules for Advanced Modeling Discuss virtual cubes List uses for lookup cubes Create and use a spread profile cube Implement moving balances in a cube Convert Currencies Discuss currency challenges Create currency dimension Create currency cube Create rules for currency conversion 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 Website:www.cynosureks.com Email:masood@cynosureks.com Page 2
  • 3. Cynosure Knowledge Solutions Pl email me at masood@cynosureks.com Create a Drill Process Create a Drill Assignment Rule Edit a drill process Integrate with IBM Cognos 8 BI Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment Integrate IBM Cognos TM1 in Cognos 8 BI portals Present Data and Reports Organize content in TM1 using application folders Use Action buttons to enhance functionality in Excel and TM1 Web reports Add worksheet controls to change the Presentation of data Integrate with Cognos BI Benefits of IBM Cognos Integration Integrate IBM Cognos with IBM TM1 COGNOS TM1 END USER ANALYSIS Data Exploration What is Data Cube Viewing Data in a Cube Calculating a View Arranging Dimensions Spread Sheet Analysis Examine InSpreadsheet browser Taking View Snapshots Slicing a View Spreadsheet Functions Organize and Distribute Results Use TM1 Web COGNOS TM1 ADMINISTRATION TM1 Architecture and Installation Describe the IBM Cognos performance management (PM) system and TM1's role in PM Identify the components of TM1 architecture Install TM1 components Configure the TM1 serves Replicate and Synchronize Servers Describe the replication process Identify replication relationships Identify possible server configurations Website:www.cynosureks.com Email:masood@cynosureks.com Page 3
  • 4. Cynosure Knowledge Solutions Pl email me at masood@cynosureks.com Replicate cubes Remove cube replications Synchronize replications Monitor Server Performance Use TM1 log files Monitor performance with control cubes Dynamically monitor TM1 server threads Monitor TM1 server performance in real time Manage the Server Broadcast messages to clients Connect and disconnect users from a TM1 server Shut down a remote TM1 server Implement TM1 Security Identify TM1 authentication options Create users and groups Configure integrated login Assign object security rights to groups Use rules to maintain security rights Use Turbo Integrator processes to maintain security Back Up and Recover Applications Create processes to back up data Plan for backup and recovery of TM1 applications Migrate Applications from Development to Production Document objects in the TM1 Application Manage the application metadata Website:www.cynosureks.com Email:masood@cynosureks.com Page 4