Forum Discussion

KG1's avatar
KG1
Icon for Resolver I rankResolver I
2 years ago
Solved

RLS Help

I need to produce a 1 page report   The top half of the page summarises all actions and their status   When the user clicks on a bar chart then the detail below should update to only show the act...
Need Help
KG1's avatar
KG1
Icon for Resolver I rankResolver I
2 years ago

Thank you for replying - the data model is very simple - 1 lookup table sorting the due date status and the 2 identical fact tables - would I apply the RLS to to the bridge table?

 

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

No problem. No, you need the RLS to still be applied to the detail table so they only see their own items, the bridge table will allow both tables (one with RLS and one without) to be filtered. In the bar chart visual you will utilize the field from the bridge table instead of your unrestricted table.

  • KG1's avatar
    KG1
    Icon for Resolver I rankResolver I
    2 years ago

    Hi  - thank you very much - that has worked perfectly

    • audreygerred's avatar
      audreygerred
      Icon for Super User rankSuper User
      2 years ago

      You're very welcome!