Forum Discussion
RLS set value - undesired behavior
I was able to partially resolve the issue by activating "apply security filter in both directions" between a bridge and dim table
That eliminates the issue for the sample file however it looks like I am out of luck for my work file because I have multiple fact tables connected through multiple bridge tables to a single dim table. I can toggle the security filter checkbox for one of the bridge tables which resolves the issue for that tables and connected data, however, it won't let me toggle security filter for all 4 bridge tables.
Edit:
Alternative workaround - add report level filter for the values that will be filtered by your role.
Don't check the "select all" box but instead manually tick each box for every value.
I was able to partially resolve the issue by activating "apply security filter in both directions" between a bridge and dim table
That eliminates the issue for the sample file however it looks like I am out of luck for my work file because I have multiple fact tables connected through multiple bridge tables to a single dim table. I can toggle the security filter checkbox for one of the bridge tables which resolves the issue for that tables and connected data, however, it won't let me toggle security filter for all 4 bridge tables.
Edit:
Alternative workaround - add report level filter for the values that will be filtered by your role.
Don't check the "select all" box but instead manually tick each box for every value.
One other question for you: Which table does the Category field come from for the Table and the Page level filter in your initial post?
In my initial post I used screenshots from my work file.
After you mentioned that you could not reproduce the issue, I made a mock-up file to reproduce it myself on a smaller scale and we've been discussing it since.
The only difference is that in the mockup there is 1 fact 1 bridge 1 dimension table.
In the work file there 4 fact 4 bridge 1 dimension table.
The security filter setting can only be activated for one of the bridge tables.
I tried creating another bridge table that linked to the whole dimension table like this
F - B -
F - B -
F - B - Dim - Bridge (with security)
F - B -
and applying the rls vallue setting as well as the security filter there. In this case the issue persists and the security filter does absolutely nothing.
The only alternative is add report level filter and manually check each box for the values there. When the role is applied only the relevant value will kick in the report level filter. Does not work if "all" is selected.