classtype

IBM Planning Analytics: Design and Develop Models in Planning Analytics Workspace (v2.0.x)

Audience

This advanced course is for data modelers.

Prerequisites

  • Knowledge of your business requirements
  • IBM Planning Analytics: Analyze Data and Create Reports (V2.0.x)

Key Topics

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

All courses

Request a Class

Please complete all fields.

1
First Name
no-icon
Last Name
no-icon
Company
no-icon

Please provide a valid email address from your business or organization. Thank you.

What do you want to learn?
Preferred Date
date_range
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right