Jedox Ideas

Let us know how we can make Jedox even better!

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

RELATED IDEAS

Semi-additive measures accross multiple dimensions

Currently you can only select one dimension in the cube. We have a requirement to average all dimensions on all hierarchy levels. That is on the very highest level, you want to see the average of everything in the cube and on all levels down.
  • ADMIN RESPONSE
    Dec 18, 2020

    Thanks for the idea. This feature has been evaluated by us and we will not implement at this time. You can, however, use the new Subsets in Rules feature (from 20.3 onward). This enables you to to Averages, Medians, Max, Min, Count and other array style functions in rules. See the What's New 2020.3 or .4 for full examples of this.

  • Guest
    Reply
    |     Jul 2, 2019
    Isn't that a matter of defining a cube rule?
  • Guest
    Reply
    |     Jul 2, 2019
    I think you can do it in a rule, but if you had semi-additive measures able to do this across multiple dimensions that would be great. Same problem when you have a "Daily Stock" cube (check stock levels on a daily basis) and your stock levels are of course not cumulative over time - when you have 3 time related dimensions for this (Year, Week, Day of Week) then using the semi-additive measures doesn't help you. Using 3 time-related dimensions makes sense because you can put them on rows and columns, whereas if you have only one (Date dimension) you can only put that on rows OR columns, i.e. you can't do an easy comparison across "same day last week" or "same week last year" etc. So I think having semi-additive measures across multiple dimensions would be great. (alternatively having the ability to have only one time-dimension but stick it's attributes against rows and columns at the same time).