I am trying to build a cube view where the client can insert suppressed row members for account, ud3, and entity with ud3 having 2000+ members. I can't figure out how to work the suppression so it only shows the top row and allows the user to enter in the suppressed rows without having all combinations visible through expansion. Currently it is showing all possible combinations or no combinations.
Thanks in advance for the help!
Hi, you need to have the parent and the children list of this parent in your row. Here is an example with the ICEntities parent:
And activating NoData suppression + Allowing Insert Suppressed Member (and not activating the suppression on Parents):
Result, by doing a right-click on ICEntities: