Jedox Ideas

Let us know how we can make Jedox even better!

Add a new idea Subscribe
Status Shipped
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

RELATED IDEAS

Ability for non-sum aggregations

Based on different Measures, some OLAP systems offer the ability to aggregate not based on sums, but for example to take the last (filled) value of an aggregation (storage value for last month of a quarter). In MS Analysis Server, this is called "LastNotEmpty". #3088
  • ADMIN RESPONSE
    Jul 2, 2019
    6.0 features calculated(dynamic) functions on POV elements and "semi additive measures" feature.
  • Guest
    Reply
    |     Jul 2, 2019
    Including allowing items like averages at consolidations would be good. Alternatively, simple PALO.AVG type functions in the rules.
  • Guest
    Reply
    |     Jul 2, 2019
    Maybe the same as this one: "Aggregation functions (count, min, max) available in rules"
  • Guest
    Reply
    |     Jul 2, 2019
    A LastNotEmpty function would require to recognise an explicit zero (in contrast to empty / not-applicable) as last stored and thus defining value