topic How to output all the names in a hierarchy using DAX? (Dynamic row level security for SSAS) in DAX Commands and Tips

How to output all the names in a hierarchy using DAX? (Dynamic row level security for SSAS)

techspert316 — Mon, 21 Nov 2022 15:21:18 GMT

Let me elaborate the question, I have a hierarchy column like this:

This is Analysis services.

As seen in the above picture 281 is the employee ID of the CEO and the rest employee IDs are his subordinates.

I want to implement Dynamic Row level security for organizational hierarchy in Analysis services.

so, for example employee id 290 logs in he should be able to see his data and his subordinates data.

please Help!

djurecic — Mon, 21 Nov 2022 21:29:28 GMT

This article should point you in the right direction:

techspert316 — Tue, 22 Nov 2022 07:08:24 GMT

thank you djurecic for replying

I tried this radacad post and it is not working in Analysis Services, please have a look