You need to grant permission for salespersons to view only the data based on their sales territory

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *