Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Already exists
Workspace Jedox Platform
Created by Guest
Created on Dec 22, 2021
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit JS-I-980 Conditional / Fallback source for form elements (dynaranges, combobxes, lists etc).

Only eveluate inner nested dynarange at lowest level of outer dynarange Merged

Often, we seperate descriptive characteristics into two dimensions in order to allow for unique combinations that prevent doubling of data in comparison to using one dimension, i.e. Region and Customer. In case of the example the same customer can be represented in multiple regions when using two dimensions while that's not possible when combining them in one dimension. Unfortunately, when nesting Region and Customer with the help of a data filter, the customers are shown underneath every level of the Region dynarange (i.e. All Regions, East, South, Germany, Belgium, etc.) which isn't useful for a report. A workaround is using hiderows, but that significantly slows down performance when dealing with medium to big datasets. Therefore, it would be nice to have a setting (when data filter is activated) for the inner dynarange to only be avaluated when a branch of the outer dynarange is expanded to the lowest level.

  • Guest
    Reply
    |
    Jan 7, 2022

    Thanks for the idea. You can already achieve this in Jedox, by using a formula as the sources of the dynarange. E.g. "=IF(PALO.ELEVEL(_con,_dim,DynaRange1)>0,_root_element,PALO.SUBSET(...))"


    However, we have logged a more generic and user friendly ideas for the product. See the merged idea.