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

4 Replies

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    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:

     

    • tchev's avatar
      tchev
      New Contributor III
      1 year ago

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

  • 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.