IBM Cognos

Objectifs

• 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

Programme

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 Planning Analytics utilities

Convert currencies

• discuss currency challenges

• review control cubes

• create rules for currency conversion

• use Planning Analytics techniques to reduce maintenance

Model data with Architect

• describe IBM Planning Analytics Architect

• record MDX queries

• customize drill-through paths

Optionnal theme

• Additional Exercise (Optional)

• Optimize and tune models (Optional)

• Customize business rules (Optional)

• Optimize rule performance (Optional)