Microsoft
70-460 · Question #66
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. See the full explanation below for the reasoning.
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
(18 responses)- A83% (15)
- B11% (2)
- D6% (1)
Community Discussion
No community discussion yet for this question.