70-467 · Question #29
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy…
The correct answer is C. Option C. Returning only blue products from the Category hierarchy requires an MDX set expression that correctly filters Category members by their associated Color attribute value.
Question
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy. You need to return only the blue products in the Category hierarchy. Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(15 responses)- A7% (1)
- B13% (2)
- C80% (12)
Why each option
Returning only blue products from the Category hierarchy requires an MDX set expression that correctly filters Category members by their associated Color attribute value.
Option A likely uses incorrect syntax or a function that does not properly traverse the attribute relationship between the Category and Color hierarchies, producing incorrect or empty results.
Option B likely filters at the wrong granularity or uses a method that fails when Category members are associated with multiple colors, returning incorrect members.
The correct MDX expression uses EXISTS or FILTER to intersect Category hierarchy members with those linked to the Blue member of the Color attribute hierarchy, respecting the attribute relationship defined in the dimension. This approach returns only Category members that have at least one associated blue product, which is the standard and most performant MDX pattern for cross-attribute set filtering.
Option D likely uses a scalar function or non-set expression that cannot be used as a named set definition, or returns all Category members rather than filtering by color.
Concept tested: MDX named set filtering using EXISTS or FILTER across attribute hierarchies
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-named-sets-in-mdx
Topics
Community Discussion
No community discussion yet for this question.
