EncartaLabs

IBM Cognos TM1 Design and Develop Models

The IBM Cognos TM1 - Design and Develop Models in Architect training course is designed to teach modelers to build a basic cube model in TM1 using the Architect tool. Through a series of lectures and hands-on exercises, attendees will learn how to set up and verify dimensions, cubes, and views, manually enter data into these structures, and define the data that users can see. attendees will also learn how to transfer data into the TM1 model, including the use of TurboIntegrator processes. This course is ideal for users who already have models built with Architect and need a high degree of customization, or whose model complexity has evolved past Performance Modeler capabilities.

The IBM Cognos TM1 -Design and Develop Models in Performance Modeler training course will teach modelers to build a complete model in TM1 mainly using the Performance Modeler tool. Through a series of lectures and hands-on exercises, attendees will learn to create and customize dimensions and cubes, import and link data, and build and maintain applications.

  • Basic knowledge of OLAP and TM1
  • Significant experience with Microsoft Excel spreadsheets (functions, macros, etc.)
  • Understanding of the metrics and drivers of your business

This IBM Congos TM1 - Design and Develop Models workshop is ideal for modelers.

COURSE AGENDA

IBM Cognos TM1 - Design and Develop Models in Architect
(Duration : 5 Days)

1

Examine the components of a TM1 model

2

Create dimensions

3

Build cubes and views

4

Load and maintain data

5

Add business rules

6

Optimize business rules

7

Transfer data into the model

8

Customize drill paths

9

Use rules for advanced modeling

10

Convert currencies

11

Model for different fiscal requirements

12

Deploy TM1 applications to the Web

13

Integrate with IBM Cognos BI

IBM Cognos TM1 - Design and Develop - Models in Performance Modeler
(Duration : 5 Days)

1

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
2

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
3

Create and Customize Cubes

  • construct a new cube
  • discuss cube properties
  • edit a cube structure
  • review and use a pick list
  • create cube calculations
4

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
5

Share Data Across Cubes with Links

  • discuss and list types of links
  • create and modify links
  • review rule- and process-based links
6

Complete the Income Statement Model

  • Complete the Income Statement Model
  • discuss the model development process
  • complete objects for the model
  • review tools to aid in model development
7

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
8

Additional Modeling Techniques

  • create dynamic subsets
  • use dimension functions
  • implement business logic
  • improve cube performance
  • use TM1 utilities
9

Convert Currencies

  • discuss currency challenges
  • review control cubes
  • create rules for currency conversion
  • use TM1 techniques to reduce maintenance
10

Model Data with Architect

  • describe IBM Cognos TM1 Architect
  • record MDX queries
  • customize drill-through paths
11

Model for Different Fiscal Requirements

  • discuss time considerations
  • use discrete time dimensions
  • implement a continuous time dimension model
12

Contribute to Planning Applications

13

Integrate with IBM Cognos BI

14

Administer IBM Cognos Insight

15

Optimize and Tune Models

16

Identify Common Data Structures

17

Customize Business Rules

18

Optimize Rule Performance

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top