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.
PARALLELPERIOD
2017 Oct New 70-768 Exam Questions are Updated Today! I have already uploaded all new practice questions here: http://certforums.net/?s=70-768 ,can have a look.