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.
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.
that did not help either. still the logged in user seems all health sytem names which he dont have access.
make sure you are not testing with a user who has workspace access above Viewer. RLS is ineffective for these users.