Home » Microsoft » 70-466 v.2 » Which Multidimensional Expressions (MDX) function should you use?
You need to configure the UserRegions role.
Which Multidimensional Expressions (MDX) function should you use?
A. USERNAME ( )
B. USERID ( )
C. CUSTOMDATA ( )
D. UNIQUENAME ( )
E. LOOKUPVALUE ( )
Correct Answer: A
Explanation/Reference:
Explanation:
From Scenario: A role named UserRegions has been created in the SSAS database that will be used to filter members in the Regions dimension based on the authenticated user.
The MDX function UserName feturns the domain name and user name of the current connection.
References: https://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/Multidimensional%20Expressions%20-%20MDX%
20%20Reference.pdf, page 350
