nerdexam
Microsoft

70-467 · Question #42

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy…

The correct answer is A. Option A. MDX named sets filter dimension members by combining a hierarchy set with an attribute constraint using functions like EXISTS or FILTER to scope results correctly.

Design BI data models

Question

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy. You need to return only the female customers in the Geography hierarchy. Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

Exhibit

70-467 question #42 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(45 responses)
  • A
    73% (33)
  • B
    16% (7)
  • C
    9% (4)
  • D
    2% (1)

Why each option

MDX named sets filter dimension members by combining a hierarchy set with an attribute constraint using functions like EXISTS or FILTER to scope results correctly.

AOption ACorrect

Option A correctly uses an MDX set expression such as EXISTS or FILTER to return only members of the Geography hierarchy that correspond to female customers, by intersecting Geography hierarchy members with the [Customer].[Gender].[Female] attribute member. This approach properly scopes the result to the Geography hierarchy while applying the gender constraint, which is the precise behavior required for the named set.

BOption B

Option B likely returns all Geography hierarchy members without correctly applying the female gender filter, producing an inaccurate or unfiltered set.

COption C

Option C likely uses an incorrect MDX syntax or function that fails to properly cross-reference the Gender attribute with the Geography hierarchy members.

DOption D

Option D likely uses CROSSJOIN or a similar expression that returns a tuple set combining both hierarchies rather than filtering Geography members by the female gender attribute.

Concept tested: MDX named set filtering with attribute hierarchies

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-named-sets-in-mdx-multidimensional

Topics

#MDX named sets#attribute filtering#dimension hierarchies#SSAS

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice