70-467 · Question #112
You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function." You need to ensure that the query executes…
The correct answer is A. Move the Product clause from line 08 to line 10. C. Move the Date clause from line 10 to line 08. The MDX error 'Members, tuples, or sets must use the same hierarchies in the function' is caused by mixing incompatible hierarchies on a single axis, and is fixed by redistributing the Date and Product clauses across axes so each axis contains only compatible hierarchy members.
Question
You execute the SalesbyCategory report and receive the following error message:
"Members, tuples, or sets must use the same hierarchies in the function." You need to ensure that the query executes successfully. Which two actions should you perform? Each Answer presents part of the solution.
Options
- AMove the Product clause from line 08 to line 10.
- BMove the Date and Product clauses on line 11 to axis 0.
- CMove the Date clause from line 10 to line 08.
- DMove the Measures clause on line 02 to axis 1.
How the community answered
(56 responses)- A64% (36)
- B11% (6)
- D25% (14)
Why each option
The MDX error 'Members, tuples, or sets must use the same hierarchies in the function' is caused by mixing incompatible hierarchies on a single axis, and is fixed by redistributing the Date and Product clauses across axes so each axis contains only compatible hierarchy members.
Moving the Product clause from line 08 to line 10 removes it from the axis where it conflicts with other hierarchies, placing it on an axis where it is compatible with the remaining members and eliminating the mixed-hierarchy violation.
Moving both Date and Product to axis 0 alongside Measures would mix measure and non-measure hierarchies on the same axis, introducing a new conflict rather than resolving the existing one.
Moving the Date clause from line 10 to line 08 relocates it to the axis alongside other compatible hierarchies, ensuring that axis 0 and axis 1 each contain only members from consistent, non-conflicting hierarchies as MDX requires.
Relocating the Measures clause to axis 1 does not address the root cause - the Date and Product hierarchies are still incorrectly co-located on the same axis and will continue to violate the same-hierarchy constraint.
Concept tested: MDX axis hierarchy consistency for multi-dimensional queries
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/mdx-query-fundamentals-analysis-services
Topics
Community Discussion
No community discussion yet for this question.