Forum Discussion
Row level security: Multiple users for one cost center
Hi. I need to add row level security to a report showing costs per department. All departments have a manager, who should have access to data for the specific department. Furthermore, the finance...
Hi Anonymous ,
You need to have your relationship with many-to-many with the filtering from the UserAcess to the CostCenter:
Then this will work properly:
File attached.
MFelix
Super User
Super UserHi Anonymous ,
For this you need to have a table dimension that has the departments access per user, then make a relationship between those users and the department table (assume you have one) then you should use the RLS on the table of Users/Departments that will flow trough the rest of the model.
Hi MFelix
I think I have done hwat you are suggesting, but it still doesn't work. I have added a test report to my question.
Thanks a lot.