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.)
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Why not B?
Because that is TSQL, not MDX.