The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

tchev's avatar
tchev
New Contributor III
1 year ago

Cube View Row Suppression for No Access

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?
Security
tchev's avatar
tchev
New Contributor III
1 year ago

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

FredLucas's avatar
FredLucas
Icon for OneStream Employee rankOneStream Employee
1 year ago

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.