Forum Discussion

tchev's avatar
tchev
New Contributor
6 months 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?

  • T_Kress's avatar
    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:

     

    • tchev's avatar
      tchev
      New Contributor

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

  • tchev's avatar
    tchev
    New Contributor

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

    • FredLucas's avatar
      FredLucas
      Contributor III

      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.