Insert Suppressed Row Members

akatsman
New Contributor III

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!

1 REPLY 1

alesage
New Contributor III

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:

aurelienlesage_1-1651243997997.png

And activating NoData suppression + Allowing Insert Suppressed Member (and not activating the suppression on Parents):

aurelienlesage_2-1651244090302.png

Result, by doing a right-click on ICEntities:

aurelienlesage_3-1651244229641.png

Aurélien