Which set expression should you use?

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.
Select and Place:


microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.