This 5-day IBM Cognos training, Code P8252G, is an intermediate instructor-led course. This offering will teach modelers how to build a complete model in TM1 mainly using the Performance Modeler tool. Through a series of lectures and hands-on exercises, students will learn how to create and customize dimensions and cubes, import and link data, and build and maintain applications.
Note: This training was developed using IBM Cognos TM1 10.2 but is applicable to both IBM Cognos TM1 v10.2 and IBM Planning Analytics.
Who should attend?
- This intermediate course is for modelers.
Pre-requisites
- Basic knowledge of OLAP and TM1
- Significant experience with Excel spreadsheets (functions, macros, etc.)
- Understanding of the metrics and drivers of your business
- It is recommended that you complete course IBM Cognos TM1: Interact with Data (V10.2) WBT.
Course Content – Detailed Objectives
Overview of IBM Cognos TM1
- review financial performance management
- identify the TM1 position in a performance management system
- describe the IBM Cognos TM1 components and architecture
- explore IBM Cognos TM1 applications
- explore the IBM Cognos TM1 environment
- manage and organize a model
Create and Customize Dimensions
- review cubes, dimensions, and elements
- create dimensions manually
- import dimensions
- edit dimensions
- create dimension calculations
- use Guided Import to create a dimension
Create and Customize Cubes
- construct a new cube
- discuss cube properties
- edit a cube structure
- review and use a pick list
- create cube calculations
Import Data
- identify data sources
- create processes to load data
- create a process to delete data in a cube
- create processes to update and maintain the model
Share Data Across Cubes with Links
- discuss and list types of links
- create and modify links
- review rule- and process-based links
Complete the Income Statement Model
- discuss the model development process
- complete objects for the model
- review tools to aid in model development
Create Applications
- explain the application types
- access an IBM Cognos TM1 application
- create a new application
- set the available clients
- apply security in the application
- activate and de-activate an application
Additional Modeling Techniques
- create dynamic subsets
- use dimension functions
- implement business logic
- improve cube performance
- use TM1 utilities
Convert Currencies
- discuss currency challenges
- review control cubes
- create rules for currency conversion
- use TM1 techniques to reduce maintenance
Model Data with Architect
- describe IBM Cognos TM1 Architect
- record MDX queries
- customize drill-through paths
Model for Different Fiscal Requirements
- discuss time considerations
- use discrete time dimensions
- implement a continuous time dimension model
