Forum Discussion
Dynamic row level security
Hi guys, When designing my model i believed my use case would be very simple, quite the opposite. The following picture is a representation of my model: It has 1 fact table surrounded by 13 ...
Hey,
Thanks for the the tips but my use case is slightly different and I've read most of those.
They're only filtering from let's say a RLS table to a region dimension to a fact.
All my 10 + dimensions have to be filtered too and I'm looking for an efficient way to 'propagate' my filter from my fact to my other dimensions.
Currently I can do this through using a custom visual that forces the user to select a slicer element, then my RLS is properly propagated.
I'm looking for alternatives to this.
Hi Anonymous ,
For all the relationships, try to change the Cross filter direction from Single to Both, which will take them treated as a single table, and will take the 'propagate' effective.
Best Regards,
Amy