Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

i2024.2.4 New Features and Improvements - Multiple Hierarchy Support for Semi-Additive Measures

Business Requirements 

If you have multiple Time Hierarchies (e.g. Standard, Fiscal, Retail, etc.) AND the need to model multiple "Balance Measures" across time, then it is cumbersome to write "glue code" to switch the measure based on the query.

 

AtScale Feature Review 

Eliminate the need to write custom code by enhancing Semi-Additive Measures to trigger their non-additive behavior when queried with a list of dimensions rather than just one!

  1. Eliminates the need to write "helper" code to show specific Measures when queries contain certain hierarchies.
  2. Easily configure "Balance" Measures using the "First/Last Value Not Empty" aggregation functions with the Design Center UI!
  3. Increases re-usability and maintainability of your measures within and across models.