Course Overview

IBM Cognos TM1: Design and Develop Models (V10.1) is an intermediate 5-day instructor course. This offering will teach modelers how to build a complete model in TM1. Through a series of lectures and hands-on exercises, you will learn how to model, link and deploy TM1 applications.

Who Should Attend

This basic course is for Modelers.

Course Certifications

This course is part of the following Certifications:

IBM Certified Developer – Cognos TM1 10.1

Prerequisites

IBM Cognos TM1: Interact with Data (V10.1) (Recommended)
Basic knowledge of OLAP and TM1
Significant experience with Excel spreadsheets (functions, macros, etc.)
Understanding of the metrics and drivers of your business
IBM Cognos TM1: Interact with Data (V10.1)

Course Content

Overview of IBM Cognos TM1

  • Explore IBM Cognos TM1 applications
  • Explore the IBM Cognos TM1 environment
  • Manage and organize a model

Identify Common Data Structures

  • Discuss Online Analytical Processing (OLAP)
  • Examine core model design principles
  • Identify the basic tasks required to create a TM1 model and deploy it

Import Data to Create Objects

  • Discuss guided import
  • Import data to create a dimension
  • Import data to create and populate a cube

Create and Customize Dimensions

  • Create dimensions manually
  • Import and edit dimensions
  • Create dimension calculations

Create and Customize Cubes

  • Construct a new cube
  • Discuss cube properties
  • Edit a cube structure

Import Data

  • 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

Customize Business Rules

  • Discuss a rule
  • Review automatically generated rules
  • Discuss and re-order rule blocks

Optimize Rule Performance

  • Discuss consolidations and sparsity
  • Enhance consolidation performance
  • Modify automatically generated statements

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

Use Advanced Modeling Techniques

  • Use dimension functions
  • Implement moving balances in a cube

Model Data with IBM Cognos TM1 Architect

  • Define drill-thru
  • Use Rules Tracer

Convert Currencies

  • Discuss currency challenges
  • Model data for currency conversion

Contribute Data to Planning Applications (Optional)

Integrate with IBM Cognos Business Intelligence (Optional)

Optimize and Tune Models (Optional)

Define Workflow (Optional)