Forum Discussion
prajaktakeni11
Helper I
2 years agoOrganizational hierarchy RLS level 2 without path function
Hello
I want to create RLS such as manager can see team members data (2 level below him ) in orgnizational hierarchy
however in my case my there are some values in my "ManagerUID" column which are not present in "EMPUID" Column because of which I cannot use PATH() funtion
For 1 level I have used following RLS dax
[UID] = left(username(),6) || [LineManagerUID] = left(username(),6) || [Email] = username() || [LineManagerEmail] = username()
Please help me to craete level 2 RLS
Thank you in advance
3 Replies
- lbendlin
Super User
Either fix your hierarchy data or use dynamic RLS.
- prajaktakeni11
Helper I
lbendlin
thank you for your reply.....can you help me out with dynamic RLS as I ma new to RLS