Which calculation should you use?

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.)

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


mk

mk

Why not B?

Jane

Jane

Because that is TSQL, not MDX.