Dynamic Row Level Security - Data schema issue

[BlueRanger]

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!

[ppm1]

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]

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.