Microsoft
70-467 · Question #112
70-467 Question #112: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #112. The question stem and answer options stay visible for context.
Design BI data models
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.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#MDX#axis hierarchies#SSAS query#hierarchy conflict