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 Multidimensional Expressions (MDX) filter.
B.
Create a member and then create a Data Analysis Expressions (DAX) filter.
C.
Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX)
filter.
D.
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 Data Analysis Expressions (DAX) filter.