SQL SERVER Tabular Model - Bi-directtional filter suggestions

Question

Hello All,

We have a requirement to show values from all dimension on Row Level Security implemented on particular dimension based Fact Table Join .

Lets say we have Fact table which is connected with 3 dimension ( dimA, dimB, dimC)

if row level security is implemented on dimA, the expectation is show only filter data on dimB and dimC based on Fact table joins.

We can meet the requirement by using bi directional filter. I am not sure if this is best way to implement when we have 10+ dimensions.

do we have any other options and suggestions for these requirement?

Thanks,

Answer 1

Hi,
Based on your description, using bi-directional filter is suitable for this scene.
Or you could add multiple mapping for RLS for each dimension, but when there are too many dimensions , it would be hard to manage all the mapping.

---

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.