You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power
View solution.
You need to grant permission for salespersons to view only the data based on their sales
territory.
What should you do?
A.
Create a member and then create a Data Analysis Expressions (DAX) filter.
B.
Create a member and then create a Multidimensional Expressions (MDX) filter.
C.
Use SQL Server Management Studio to create a role. Then create a Data Analysis
Expressions (DAX) filter.
D.
Use SQL Server Management Studio to create a role. Then create a Multidimensional
Expressions (MDX) filter.
dupliated question
Create a role, so everyone member of salesdata will have the same permissions. Filter out data using DAX filter.
D – is correct
I mean “C”