Which set expression should you use?

DRAG DROP
A SQL Server Analysis Services (SSAS) cube named Sales includes a dimension named
Date that defines a hierarchy named Calendar. The Calendar hierarchy consists of Year,

Quarter, and Month levels. The Type properties of the Date dimension and its attributes are
appropriately configured to mark the dimension as a time dimension.
You are creating a Multidimensional Expressions (MDX) query that will return sales for each
month of 2011 and a three-month moving average of sales (labeled 3MMA), as shown in the
following diagram.

You need to complete the MDX query.
Which set expression should you use? To answer, drag the appropriate expression to the
answer area.

DRAG DROP
A SQL Server Analysis Services (SSAS) cube named Sales includes a dimension named
Date that defines a hierarchy named Calendar. The Calendar hierarchy consists of Year,

Quarter, and Month levels. The Type properties of the Date dimension and its attributes are
appropriately configured to mark the dimension as a time dimension.
You are creating a Multidimensional Expressions (MDX) query that will return sales for each
month of 2011 and a three-month moving average of sales (labeled 3MMA), as shown in the
following diagram.

You need to complete the MDX query.
Which set expression should you use? To answer, drag the appropriate expression to the
answer area.

Answer: