Apply Security filter in both direction - checkbox restriction

[rveerasamy]

We have SALES REP DIM table connected with other 6 master table. We have different level of RLS user's. When we trying to activate the apply security filter in both direction checkbox. It giving the error message of one relationship per table is allowed.

Can you please give some suggestion how to activate the Both direction filter in RLS?

If not then how to change my model for implementing the RLS access filter also

Thanks in advance!

[tex628]

BI-Directional RLS filter should only really be necessary when if you have a many to one relationship with crossfilter "both".
From the image i see one, if you have more than that i believe you will have an issue. 

If you can provide an image of the different relationships that we want to filter it would help alot!

/ J

[rveerasamy]

Hi @tex628 , Below is my model. SALES REP DIM master table connected 5 master tables (Market, Divison, Company, Distributor, Zone). other than that we have 3 user tables used to giving the access based on Divison, Company level(Divison Team, Management team, AD Plus Team).

For example one divison level user entering via RLS they want to see their company & zone only (filtering flow marked in blue line).  Same for management team (company level access) they want to see their company & divison only.

I'm not able to activate the more than one checkbox. Currently it's displaying all the master info in pagelevel filter panes

Can you please guide me 

[tex628]

Hi, 

Market, Zone, Division and Company, can you merge these tables into Sales Rep Dim without causing any issues? 

/ J