You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Customer A, Projected Revenue is defined as 150percent 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.
CREATE MEMBER CurrentCube.[Measures].[Projected Revenue]AS [Measures].[Total Sales];SCOPE
([Customer].[Customer Name].MEMBERS, [Measures].[Projected Revenue]);[Measures].[Total Sales] * 1.1;
IF [Customer].[Customer Name].CurrentMember.Name = “Customer A”THEN [Measures].[Total Sales] *
1.5END IF;END SCOPE;
B.
CREATE MEMBER CurrentCube.[Measures].[Projected Revenue]AS [Measures].[Total Sales] * 1.1;SCOPE
([Customer].[Customer Name].MEMBERS, [Measures].[Projected Revenue]);[Customer].[Customer Name].
&[Customer A] = [Measures].[Total Sales] * 1.5;END SCOPE;
C.
CREATE MEMBER CurrentCube.[Measures].[Projected Revenue]AS [Measures].[Total Sales] * 1.1;SCOPE
([Customer].[Customer Name].&[Customer A], [Measures].[Projected Revenue]);THIS = [Measures].[Total
Sales] * 1.5;END SCOPE;
D.
CREATE MEMBER CurrentCube.[Measures].[Projected Revenue]AS CASE WHEN [Customer].[Customer
Name].CurrentMember.Name = “Customer A”THEN [Measures].[Total Sales] * 1.5 ELSE [Measures].[Total
Sales] * 1.1 END
OK
C