Forum Discussion

BlueRanger's avatar
BlueRanger
Frequent Visitor
3 years ago

Dynamic Row Level Security - Data schema issue

Hello,

 

I am struggling to implement dynamic row-level security access to my data model. I have identified two relationships that are causing the problem (see highlighted in image below). If either of the highlighted relationships is deleted from the model, RLS will work; however, this causes my model to have erroneous reporting numbers. As you can see below, the user table is connected to the Organization table via "Location ID". The Organization table is connected to the Org Mapping Table via "Location ID". And, the Org Mapping Table is connected to the Item Sales table via "Organization Key".

 

Any possible solutions or ideas would be greatly appreciated. 

 

Thanks!

Need Help

2 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    You should avoid bi-directional filters. The one is likely needed for RLS in your case, but you should learn how to pass filters around with CROSSFILTER or TREATAS to avoid bi-di relationships, when possible. Can you go straight from the User Location Table to the Org Mapping table on location_id?

     

    Pat

    • BlueRanger's avatar
      BlueRanger
      Frequent Visitor
      3 years ago

      Hi Pat,

       

      Thank you for your reply. I will take a look into CROSSFILTER and TREATAS. I am able to connect from the user location table to the org mapping table on location_idS. Unfortunately, I am running into the same issue as before with this new relationship.