Microsoft
70-460 · Question #37
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer…
The correct answer is C. Option C. See the full explanation below for the reasoning.
Question
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer. You need to calculate the Projected Revenue as efficiently as possible. Which calculation 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
(38 responses)- A5% (2)
- B11% (4)
- C71% (27)
- D13% (5)
Community Discussion
No community discussion yet for this question.
