RLS

[odeddror]

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