IBM Planning Analytics: Design Design and Develop Models in Planning Analytics Workspace (v2.x)
- Course Code P8462G
- Duration 5 days
Course Delivery
Jump to:
Course Delivery
This course is available in the following formats:
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopThis 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.
Course Schedule
TopTarget Audience
TopThis course is intended for beginners and professionals interested in intuitive solution designs for analytics, planning, and profitability.
Course Objectives
TopBy 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
Course Content
TopOverview 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
Course Prerequisites
Top- Knowledge of your business requirements
- Recommended: IBM Planning Analytics: Analyze Data and Create Reports (v2.x) [P8457G]