You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the
product. For all other products, Projected Revenue is defined as 110 percent of the Total
Sales of the product.
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
ok