Hiding part Dimension values from some users

Question

Hi all,

We have Tabular model with unit Dimension ( like :Hospital 1, Hospital 2, etc).

We want to hide few units(hospitals) from dimension member list to the Users .

Rows for all the hospitals will be used for some other Measure calculation so cant really filter out of query.

ANy guidance is appreciated .

Thanks

Answer 1

Hi,

As per my understanding for this scene, you could consider trying Dynamic Row Level Security feature.
Check this tutorial ,see if it resolves your issue :
Bi-Directional Cross-Filtering in Analysis Services Tabular 2016 for Dynamic Row Level Security

Hope this helps.
Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.