Forum Discussion
Crossfilter and row level security
Hello, I have the following model for a report: I've been asked to implement RLS and I'm having some trouble figuring out the correct method. In my original model table 1 does not exi...
Thank you for the response.
I have tried your suggestion. In the example above, when I use 'View as role' to check the RLS, I can see that table 1 filters to 2 rows with 2 IDs which is correct. These 2 IDs from table 1 succesfsully filter table 2. I have set the relationship direction to 'both' between table 2 and 3, but it does not perform any filters on table 3 and I am struggling to understand why. Any advice would be appreciated.
Kind Regards
HI Scocal123,
It sounds strange, I'd like to suggest you extract these three table to a standalone report to exclude other filter effects and try again.
Regards,
Xiaoxin Sheng