You need to configure the Employees roles so that users can query only sales orders for their respective sales territory

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee. The table contains employee details,
including the sales territory for each employee. The table also defines a column named
EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and
logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for
their respective sales territory.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee. The table contains employee details,
including the sales territory for each employee. The table also defines a column named
EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and
logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for
their respective sales territory.
What should you do?

A.
Add a row filter that implements the LOOKUPVALUE and USERNAME functions.

B.
Add a row filter that implements only the CUSTOMDATA function.

C.
Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.

D.
Add a row filter that implements only the USERNAME function.



Leave a Reply 1

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


Ralph

Ralph

username function to compare logged on username with alias column of dimempluee table.
lookupvalue to find the salesterritory of that employee
“A”