Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using RLS with Dynamic filter

I needed some help with the RLS in my model.    Trying to set up RLS on my dimensions so that it gets filtered in to the transaction as well. But, i was    I have 2 dimension table with Products ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Based on what I got

 

The first and the third table should join on the region.

And in you should create a role to filter the first table 

table1[email] = userprincipalname()

 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks amitchandak 

     

    If i join the user and the region that is going to be a many to many relation. 

    Sorry if i didn't explain this properly. My intention is to drive this in such a way that if the user is assigned the Region in the AD ( which is the first table - User ) that should drive the region filter in the dimension also.