Let us know how we can make Jedox even better!
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.
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.