Forum Discussion
RLS for Org Hierarchy with Multiple Managers
Current State
- I currently have RLS implemented for the following scenario:
Manager -> MD -> VP -> SVP -> C-Suite - Each position has one or more work groups that report to them.
- I have 3 types of tables:
- Emp Table that has emp details (emp num, mgr emp num, work email),
- a mapping table that maps emp num to Work Groups
- Detailed expenses divided by categories for each Workgroup i.e LTE has expense details for LTE Category for all workgroups and so on
My model looks like:
- RLS implemented using path and path contains function:
PATHCONTAINS(
Emp_Hierarchy[Hierarchy],
MAXX(
FILTER(
'Emp_Hierarchy',
[work_email_address] = USERPRINCIPALNAME()
),
Emp_Hierarchy[emp_nbr]
)
)
Issue:
I need emp 3 and 5 to see the same data that 6 can see even though they report to 6. Similarly, I need 8 to see the same data that 10 can see.
How can i implement this?
1 Reply
- foodd
Community Champion
There is a great deal of thought out there on implementing RLS. Would it not be simpler to leverage security groups, where a security group would always break a workgroup hierarchy tie you are running into? Start with Soheil Bakhshi and then move over and read what Reza Rad has to say. He did write an entire book on the topic.
