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: 
How is that right? Date.Calendar.lag(2) would apply to the year level, not the month.
Is the question asking for the averages of specific months for the previous 3 years? Question is too vague.
0
0
Answer is because in MDX, I suppose [Date].[Calendar].Lag(2) = [Date].[Calendar].CurrentMember.Lag(2). I suppose it isn’t necessary to specify the level of hierarchy?
0
0
agree
0
0