Hi there,
I have the following schenario two facts tables 3 (Date, Customer,Branch) dim feeding both and I need to implement RLS
Basiclly users need to see there employees activity and 1 users can have multiple branches I have two options
RLS1 - I attach the security table to the branch it filter correctly but it broke on date and customer
RLS2 - I attach the security table to both Fact table it filter correctly bot no filter on all Dim table
Please see images (RLS1 & RLS2) with code and help me to fix this model
Thanks,
Oded Dror
