You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure.
The measure computes the sales amount for the same time period of the previous year. (Line numbers are
included for reference only.)
01 CREATE MEMBER CURRENTCUBE.Measures.SamePeriodPreviousYearSales AS
02 (Measures.[Sales Amount],
03 ________________ (
04 [Date Order].[Calendar].[Calendar Year],
05 1,
06 [Date Order].[Calendar].CurrentMember)),
07 FORMAT_STRING = “#,#.00”;
You need to complete the MDX statement.
Which MDX function should you use in line 03?
To answer, select the appropriate MDX function in the functions list.
A.
CLOSINGPERIOD
B.
LASTPERIODS
C.
MTD
D.
OPENINGPERIOD
E.
PARALLELPERIOD
F.
PERIODSTODATE
G.
QTD
H.
WTD
I.
YTD
E