nerdexam
Microsoft

70-466 · Question #98

You need to configure the UserRegions role. Which Multidimensional Expressions (MDX) function should you use?

The correct answer is B. USERNAME ( ). The MDX USERNAME() function returns the domain and username of the currently connected user, enabling dynamic dimension security that filters cube data based on who is logged in.

Configure and maintain an analysis services database

Question

You need to configure the UserRegions role. Which Multidimensional Expressions (MDX) function should you use?

Exhibit

70-466 question #98 exhibit

Options

  • AANCESTOR ( )
  • BUSERNAME ( )
  • CFIRSTSIBLING ( )
  • DLEAD ( )
  • ECOUSIN ( )

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    76% (22)
  • C
    7% (2)
  • D
    10% (3)
  • E
    3% (1)

Why each option

The MDX USERNAME() function returns the domain and username of the currently connected user, enabling dynamic dimension security that filters cube data based on who is logged in.

AANCESTOR ( )

ANCESTOR() navigates upward in a hierarchy to retrieve a member at a specified level relative to a given member; it performs hierarchy traversal, not user identity lookup.

BUSERNAME ( )Correct

USERNAME() returns the authenticated user's identity in the form DOMAIN\username at query time. In a role's allowed member set expression, comparing USERNAME() against a security mapping table or a dimension attribute lets SSAS dynamically restrict which members each user can see, which is exactly what a UserRegions role requires.

CFIRSTSIBLING ( )

FIRSTSIBLING() returns the first member among the siblings of a specified member; it is a positional navigation function with no relationship to user identity.

DLEAD ( )

LEAD() returns the member that is a specified number of positions after a given member along a level; it is used for time-series navigation, not security filtering.

ECOUSIN ( )

COUSIN() returns the member at the same relative position under a different parent as a specified child member; it is a structural navigation function unrelated to user identity.

Concept tested: MDX USERNAME() function for dynamic dimension security

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/username-mdx

Topics

#MDX security#USERNAME function#dimension security#roles

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice