Which expression should you use in the calculation designer?

You are creating a calculated measure in a sales cube by using a Multidimensional
Expressions (MDX) calculation. The cube includes a date dimension. The date dimension
has a hierarchy named Calendar that includes Calendar Year, Month, and Day attributes.
The calculated measure must calculate the year-to-date sales for the current slicer. The
MDX calculation must work for as many hierarchy levels as possible.
You need to create a calculated measure for the cube that meets the requirements.
Which expression should you use in the calculation designer? (More than one answer choice
may achieve the goal. Select the BEST answer.)

You are creating a calculated measure in a sales cube by using a Multidimensional
Expressions (MDX) calculation. The cube includes a date dimension. The date dimension
has a hierarchy named Calendar that includes Calendar Year, Month, and Day attributes.
The calculated measure must calculate the year-to-date sales for the current slicer. The
MDX calculation must work for as many hierarchy levels as possible.
You need to create a calculated measure for the cube that meets the requirements.
Which expression should you use in the calculation designer? (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 *


Xman

Xman

I will say D

Dim

Dim

B is wrong answer and does not work on a day level.
In day level it gives you month to data and not year to date dates.
D is absolutely the correct one.