Forum Discussion
RLS different level
Hi, I have a dimension department table that filter the factstable. One ofthis table is the sales pr employee. How can I create a RLS where the manager of a department can see the sales of ALL d...
Hi Anonymous ,
The first thing to make this successful would be that your data actually is separated that way so it is possible. You have to be able to slice your data in that manner or RLS won't work.
Assuming that your data can be sliced in that manner, you just create roles that have both department and employee filters. Then, in the Service, you put that manager into the apropriate two roles - the one that can see those department(s) that you want and the employee(s) that you want.
I end up in making new calculations based on userprinciplename. Duplicate/seperate data would be to much.