Cours: Essentials for IBM Cognos TM1 (V10.1)

Essentials for IBM Cognos TM1 (V10.1) is a five-day, instructor-led course that teaches modelers basic techniques for building a TM1 model, and how to support the model by creating reports, templates and analyses. Through hands-on workshops, you will first use an existing model to create subsets, filters, and views that let you easily analyze data relevant to you, and create and format reports and templates. You will also use the personal analytics tool IBM Cognos Insight to create analyses and plans and publish them to TM1. Next, you will build and populate a TM1 model by creating dimensions, cubes, and rules, and loading data into it. You will also create, deploy and use managed planning applications that enable users to contribute to plans and forecasts on the Web using controlled workflow.

You will receive two complete course books containing eight days worth of material. The modules listed below are intended to be covered in class. You can work on the remaining optional modules, or revisit modules covered in class, by accessing eLabs for 30 days after the course is complete. Please continue reading for more details.

Voir ce cours dans d'autres pays

Schémas de filière:

• IBM Cognos TM1 v10.1 et IBM Cognos Insight v10.1

Début

Modelers who, in addition to building models, need to create reports, templates, and analyses for themselves and others.

Début

You should have:

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

Début

Please refer to course overview.

Début

A1: Examine TM1 Components

• Understand how TM1 enables financial performance management
• Identify the TM1 user community
• Describe the components of TM1

A2: Customize Cube Views in IBM Cognos TM1

• Understand the solution a model represents
• View cube data from difference perspectives
• Use aliases to display alternate element names
• Filter subsets to view only specific elements
• Differentiate between static & dynamic subsets
• Add user-defined consolidations in subsets

A3: Enter and Spread Data

• Store private data in sandboxes

A5: Create Dynamic Reports with Active Forms

• Create interactive reports and data input templates using Active Forms
• Customize Active Forms using TM1 Functions
• Apply formatting to Active Forms
• Add Action buttons to enhance functionality

A8: Analyze Data in IBM Cognos Insight

• Import data from various sources
• Refresh previously imported data
• Analyze and calculate data in your workspace
• Choose an effective chart for your analysis
• Design a compelling workspace with widgets, tabs, and themes
• Publish a workspace

A9: Explore Data and Edit Subsets in TM1 Web

• Create a new cube view
• Work with a TM1 cube view on the Web
• Build simple and complex subsets in TM1 Web
• Create custom consolidations in TM1 Web

D1: Overview of IBM Cognos TM1

• Explore IBM Cognos TM1 Performance Modeler
• Create a new server and organize the model

D4: Create and Customize Dimensions

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

D5: Create and Customize Cubes

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

D6: Import Data

• Create processes to load data
• Create a process to delete data in a cube
• Create processes to update and maintain models

D7: Share Data Across Cubes with Links

• Discuss and list types of links
• Create and modify links
• Review rule and process based links

D8: Customize Business Rules

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

D9: Optimize Rule Performance

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

D10: Complete the Income Statement Model

• Discuss the model development process
• Complete objects for the model
• Review tools to aid in model development

D11: Create Applications

• Explain the application types
• Access an IBM Cognos TM1 application
• Create a new application

Optional Modules

The following modules are not intended to be taught in class, but may be covered if time permits. You can access eLabs for 30 days after the course is complete to work on any module. This lets you work with the configured products and student data by remotely accessing images using just a Web browser. While your time on eLabs is independent and not supported by an instructor, we encourage you to visit the Cognos eLearning forum on the Learner Portal to post and answer questions and learn more about TM1 from other participants.

A3: Enter and Spread Data

• Edit individual cells
• Spread data to multiple cells at once
• Exclude cells from being adjusted
• Enter data quickly using shortcuts

A4: Work with Spreadsheets

• Differentiate between a slice and a snapshot
• Manage TM1 data through Microsoft Excel
• Use TM1 worksheet functions
• Create reports in Microsoft Excel and PDF formats

A6: Work with Planning Applications

• Explain the different application types and connection modes
• Access an IBM Cognos TM1 application
• Identify the user roles and workflow states
• Enter data using shortcuts and spreading
• Submit and reject data
• Reorganize the grid

A7: Explore Data in IBM Cognos Insight

• Describe the uses of IBM Cognos Insight
• Import data into a workspace
• Navigate and explore the data
• Restructure the data
• Add calculations and highlight exceptions

A10: End to End Workshop

AA: Organize and Distribute Content

D2: 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

D3: Import Data to Create Objects

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

D12: Use Additional Modeling Techniques

• Use dimension functions
• Implement moving balances in a cube

D13: Convert Currencies

• Discuss currency challenges
• Model data for currency conversion

D14: Model Data with IBM Cognos TM1 Architect

• Define drill-thru
• Use Rules Tracer

D15: Model for Different Fiscal Requirements

• Use discreet time dimensions
• Implement a continuous time dimension model

DA: Contribute Data to Planning Applications

DB: Integrate with IBM Cognos Business Intelligence

DC: Optimize and Tune Models

DD: Define Workflow

Début