Forum Discussion
How to filter dimension based on Dynamic RLS applied to another dimension
Hi sumanthkakarla , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.
It is not clear which table has the USERPRINCIPALNAME() RLS rule applied, but that table must be able to control the parts of the data model where you want RLS to apply. If you have bidirectional links then RLS will be ineffective unless it is applied on both sides.
Thank you for your replu lbendlin , here is the Dynamic RLS that i have applied to one of the bridge table.
if the logged in user has access to 'ALL' accounts then i sould not apply any filters and show all the data to the logged in user if not i should display data only access to that particular user.
That looks ok (aside from the unfortunate table name. The actual bridge table is client_lookup).
With this setup in place, what is the issue you are observing?
the issue that i am observing here is, the filters are not working as expcted, as shown in the below image ( highlighted in yellow), i have three visual filter, HEalth SYstem, Client Facility Account Name and Test ID Name , when i apply Dynamic RLS i expect the Health Ssystem should show only assigned health system names which are assigned to that user instead it is showing all the health system names in that dim table, so the fact is not filtering the dim table, similar kind of case with other visual filters, what am i doing wrong here and how to fix it
Change the health system dimension join to single direction, dimension to fact.