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 EmployeeAliaswhich 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 CUSTOMDATA functions.
B.
Add a row filter that implements the LOOKUPVALUE and USERNAME functions.
C.
Add a row filter that implements only the USERNAME function.
D.
Add a row filter that implements only the CUSTOMDATA function.
=’Sales Territory'[Sales Territory Id]=LOOKUPVALUE(‘DimEmployee'[Sales Territory Id], ‘Employee Security'[Login Id], USERNAME(), ‘Employee Security'[Sales Territory Id], ‘Sales Territory'[Sales Territory Id])
In this formula, the LOOKUPVALUE function returns all values for the Employee Security[Sales Territory Id] column, where the Employee Security[Login Id] is the same as the current logged on Windows user name, and Employee Security[Sales Territory Id] is the same as the Sales Territory[Sales Territory Id].
The set of Sales Territory IDs returned by LOOKUPVALUE is then used to restrict the rows shown in the Sales Territory table. Only rows where the Sales Territory ID for the row is in the set of IDs returned by the LOOKUPVALUE function are displayed.
0
0
show this sample: https://msdn.microsoft.com/en-us/library/hh479759.aspx
0
0