topic Re: RLS path in DAX Commands and Tips

RLS path

syasmin25 — Thu, 16 Jul 2020 13:31:04 GMT

I am pretty new to RLS and have been trying to implement it in a certain way.

My table above is a sample. I am trying to create RLS here based on the levels. Normally I can create 3 roles for 3 levels where,
Level 1 is regular employees
Level 2 is supervisor of employees
Level 3 is the manager/head of the building (based on the BuildingID)

I am trying to create RLS where the manager (Level 3) will be able to see the data for people below them by filtering through. For example when the manager of BuildingID='233' logs in, they can filter through the report to see people they are assigned to.

It would be clickable in the filter pane. However, I am more used to on doing DAX calculations when the manager ID is on a different column and this seems to be a new scenario. I have tried a couple of methods and so far have not been successful. Any kind of help here would be much appreciated.

Re: RLS path

lbendlin — Thu, 16 Jul 2020 13:43:02 GMT

Is your sample table dominating the data model (does it sit at the outer fringe of the star/snowflake)? Have you defined the RLS rules for it?

Re: RLS path

syasmin25 — Thu, 16 Jul 2020 13:47:44 GMT

Yes I have applied it. It works with the data model perfectly. I am just struggling to create hierarchy so that the manager can view the reports view of the employees below him.

Re: RLS path

syasmin25 — Thu, 16 Jul 2020 13:48:47 GMT

I know how to create the path calculations when it has the manager ID in a seperate columns but unfortunately that is not the case here.

Re: RLS path

lbendlin — Thu, 16 Jul 2020 13:50:47 GMT

you do that by defining the rules for each role in the table. Doesn't matter if it's the same column.

Re: RLS path

syasmin25 — Thu, 16 Jul 2020 13:53:13 GMT

How would I be doing that here? I am sorry, I am really new to RLS.