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?

Question

Accepted Answer

A. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter. In SSAS tabular models, security is enforced through roles created in SQL Server Management Studio, with row-level restrictions defined using DAX filter expressions that limit data visibility per user. DAX is the native query and expression language for tabular models, making it the correct choice for filtering rows by sales territory.

Answer

B. Create a member and then create a Data Analysis Expressions (DAX) filter. 'Create a member' is not a valid step for configuring security in SSAS tabular models - role creation is done in SSMS or SSDT, not by creating dimension members.

Answer

C. Create a member and then create a Multidimensional Expressions (MDX) filter. MDX filters apply to SSAS multidimensional models, not tabular models; tabular models use DAX expressions for row-level security.

Answer

D. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter. MDX is the query language for multidimensional SSAS models and is not supported for row-level security in tabular models, which require DAX filters.

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.

Question

Exhibit

Options

How the community answered

Why each option

Topics

Community Discussion