SSAS Tabular Dynamic Row Level Security

[Anonymous]

Hi all,

I am currently setting up the security matrix for my SSAS tabular models. My company has alot of products by brands. Each product teams are allowed to view their own brand product. However for management level, they should see all. How do I setup the management level people to see all? Do I really need to list down all the product brands which are up to thousands?

User A - Brand ABC

User B - Brand DEF

User C - Brand DEF

User D - ALL <- All brands

How should I setup my security matrix table and also the DAX filter to achieve the said result.

Thanks!

Max.

[v-chuncz-msft]

@Anonymous,

You may take a good look at the Tutorial: Dynamic row level security with Analysis services tabular model.