Hierarchical RLS with multiple managers

[Anonymous]

Hello,

URGENT!!!!
Need to apply Hierarchical RLS for employees with multiple managers. But i am getting following error.

EmpIDManagerIDPath

E2004	E188	#ERROR
E2005	E188	#ERROR
E2005	E182	#ERROR
E188	E70	#ERROR
E182	E161	#ERROR
E70	E146	#ERROR
E161	E146	#ERROR

Here is the dummy data.

Can anyone help me with a solution for this scenario.
Thanks in advance!

[v-cgao-msft]

Hi @Anonymous ,

EmpID.E2005 has two and corresponds to different ManagerIDs:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Hello, 
Thanks for response.
I need a solution for multiple managers. Actually one employee have 2 managers. Is there any way to solve this ?

[amitchandak]

@Anonymous , It is giving a duplicate value error in empid column. Also a mgr d need to be in emp if too

Check for any duplicate in emp id column

[Anonymous]

Hello, 
Thanks for response.
I need a solution for multiple managers. Actually one employee have 2 managers. Is there any way to solve this ?