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
Request a Class
Please complete all fields.