Invert hierarchy in slicer in Application Studio with expand and collapse enabled

Jose Salinas

Hi everyone,

I was looking to improve report performance by converting some Application Studio reports from hyperblocks to slicers. At the moment, I have a hyperblock where chart accounts are defined on rows. In these hyperblocks, I have selected base level members including parents and have inverted the hierarchy so that the children sit on top of the parent. I also enabled expansion and collpase of members within the account node. I am trying to replicate this in a slicer but dont see option to invert the hierarchy on a slicer when the expand or collpase option is enabled. Has anyone been able to invert a hierarchy within a slicer along with the expand and collapse feature? If so, would you be willing to share how you were able to accomplish this? I have not found option in slicer but I may be looking in wrong place. Thanks in advance for the help.

Best regards,

Jose

John Robson

You are right to use slices for performance reasons. Invert hierarchy is supported but currently only when the expand/collapse property of the slice is set to False - i.e. the slice is not drillable. Here is an example: