IBM Planning Analytics: Design Design and Develop Models in Planning Analytics Workspace (v2.x) [TDS_P8462G]

OVERVIEW

This course explores the IBM Planning Analytics Workspace, how to create dimensions, cubes, and business rules. Learners will also delve into loading and maintaining data, optimizing their business rules, and learn how to transfer data into a model.

This course also explains how to customize drill paths, using rules for advanced modeling, and converting currencies.

Finally, learners will learn how to create models for different fiscal requirements.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

OBJECTIVES

By the end of this course, learners should be able to:

• Identify the TM1 position in a performance management system
• Describe TM1 components and architecture
• Manually create dimensions, import, and edit them
• Construct and edit a cube
• Identify data sources
• Create processes to update and maintain a model
• Review, disable, and enable auto-generated rules
• Optimize rules using a SKIPCHECK statement
• Troubleshoot rules and feeders
• Link cubes with different dimensions
• Use Planning Analytics as a data source
• Push data to a cube
• Create a drill process and drill assignment rules
• Utilize a lookup cube and attributes in rules
• Create rules for currency conversion
• Use Planning Analytics to reduce maintenance
• Use discreet time dimensions
• Implement a continuous time dimension model

AUDIENCE

This course is intended for beginners and professionals interested in intuitive solution designs for analytics, planning, and profitability.

CONTENT

Overview of IBM Planning Analytics • Modeling in IBM Planning Analytics: overview • IBM Planning Analytics: data tier • In-memory data storage • Calculating versus caching data • Important files in TM1

Create dimensions • What is a dimension? • What are weights? • Time dimensions • Member attributes • Hierarchies

Load and maintain data • What is TurboIntegrator? • Defining data sources and process parameters in TurboIntegrator • Validate and run processes • TurboIntegrator chores

Add business rules • What are rules? • How do you create a rule? • Review rule processing • Use a rule to override aggregation • Use a function in a rule

Optimize rule performance • Understanding consolidations and sparsity • Optimize your rules using SKIPCHECK • Using feeder statements • Inter-cube feeders • Feeding string rules • Trace cell values and feeders

Transfer data into your model • Link cubes with different dimensions • Review TurboIntegrator • Dealing with data • Use IBM Planning Analytics as a data source • Tips for scripting in TurboIntegrator

Customize drill paths • View related data • Create a drill path

Use rules for advanced modeling • Describe a virtual cube • Utilize a lookup cube • Use relative spreading and a spread profiles cube • Use attributes in rules

Convert currencies • Converting currency: overview • Review control cubes

Model for different fiscal requirements • Understanding time • Discrete time dimensions • Continuous time dimensions • Develop a continuous time model