Cube Rules: The Calculation Engine
1 Day Course
Price: $599 USD per student
Throughout the course, learners will develop an understanding of cube rules, the Planning Analytics (TM1) equivalent of Excel formulas, and their fundamental role in Planning Analytics (TM1) modeling.
The course will also explore how Excel modeling techniques and methods translate into cube rule development and model configuration, highlighting key similarities and differences between cube rules and Excel formulas.
Using an Income Statement and Commission Rates Cube, we will systematically apply and analyze various rules and calculations. Beginning with a basic sales commission expense rule, we will progressively introduce more dynamic rules that account for multi-department exceptions, commission threshold flags, and time-based commission changes.
Additionally, we will explore best practices for optimizing and scaling rules through cube feeders, leveraging real-world sales data examples to illustrate key concepts.
Register now!
Contact us to register and schedule training or ask questions about the courses.
Unit 1: What are Cube Rules?
Cube Rules Overview Basic Syntax of a Cube Rule When to Use Consolidations Instead Rule Order of Evaluation
Unit 2: Intra-Cube Rules
Creating a Simple Rule How to Create Exceptions for Rules Using Functions in Cube Rules
Unit 3: Inter-Cube & Consolidated Rules
Rules Between Cubes Disabling a Rule Conditionally Resolving Level of Detail Issues Consolidated Rules to Override Aggregations Performing a Rule at All Levels Creating a Ratio Rule Creating Rules for String Cells
Unit 4: Skipcheck & Feeders
What are Feeders and Why Do We Need Them? When do Feeders Execute? Examine Common Feeder Examples