i2024.2.4 New Features and Improvements - Calculation Group References in Calculated Measures
Business Requirement
Simple KPIs that require the use of in-line aggregation over time frames are tightly coupled to both the Time-Frame and the Time Hierarchy. If I want to evaluate the same basic calculation over different time-frames or Time Hierarchies then I have to create many copies of my basic calculation with boilerplate modifications.
- Hard to write and maintain
- More complexity in the model confuses end-users, requiring more training.
AtScale Feature Review
- Put the boilerplate components in a Calculation Group!
- Use the new Calculation Group "Wildcard" expression Syntax:
- Don't reference Hierarchies by Name.
- Instead of Level Name references use Time Type references.
- Use tuple syntax in the simple calculation to automatically scope the Measure by the boiler plate Calculation Group expression.