DynaRanges already allow to give basic formatting and define which levels are displayed and which can be drilled down to. At bigger Jedox rollouts we faced the difficulty to point out to users that they can drill down certain parts of the report and had to work with conditional formatting. It would be great, if this would be supported natively by Jedox. This could be achieved by either of:
1. '+' - icon in front of element (selectable in dynarange options)
2. mouseover effect (chaning mouse icon or miniture tooltip)
3. formatting of drillable levels according to formatting in dynarange setting
This is useful option for clients since they have used it in many other software products and ask to have it in Jedox as well. It is partly possible with workarounds, but not without limitations and performance downsides. I encountered numerous times when users had to learn for some time to understand Jedox logic for opening and collapsing consolidated elements. We could not tell customers that they could open or close bold elements because we use bold a lot in rows and columns even without dynaranges because of required design.
Our current workarounds:
Option 1: Add ± before name in attribute for consolidated elements
Option 2: Set of complex formulas for conditional formattings inside of Dynarange with "+" @ or "-" @ formats and indent and bold formatting for additional column for an attribute. In this case there will be + and - functionality but clicking on an element will not be possible. But if you don't need to show alias, it will work in just 1 column.
It sounds easy, but considering it was done for Dynatables and not for Dynaranges, it should be very hard to implement?