Cube View Row Suppression for No Access

tchev
New Contributor

Is there an ability to suppress rows on a Cube View or Ad Hoc Grid if the user does not have access to the cell?

4 REPLIES 4

T_Kress
Contributor III

If you use the row suppression option as True for Suppress Invalid Rows, that works.  It suppresses invalid intersections as well as rows for which the user does not have access to that element.

I just tested and this suppression option works for access suppression too:

T_Kress_0-1720471693380.png

 

Teresa C. Kress
Principal Delivery Manager Partner Enablement | OneStream Software

tchev
New Contributor

Thanks for these insights! Can you also do this based on Read Only cells?

tchev
New Contributor

Thanks for these insights! Can you also do this based on Read Only cells?

No, there's not a "suppress Read Only rows" feature currently, you could suggest it using Idea Stream though.

One option you could consider would be to tag those accounts using the Text attributes and filter them out of the CV based on that. You could use something like: A#GroupAccount.Base.Where(Text1 <> ReadOnly)

If the read only logic is more complex than you might want to consider using a XFBR rule to return the list of accounts depending on the use case.