Microsoft
70-466 · Question #52
70-466 Question #52: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.
Build an analysis services database
Question
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 CURRENT CUBE.Measures.SamePeriodPreviousYearSales AS
02 (Measures.[Sales Amount],
03
04 [Date Order].[Calendar].[Calendar Year],
05 1,
06 [Date Order].[Calendar].CurrentMember),
07 FORMAT_STRING = "$#.##",
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.
Options
- ANONEMPTYCROSSJOIN
- BOPENINGPERIOD
- CORDER
- DORDINAL
- EPARALLELPERIOD
- FPARENT
- GPERIODSTODATE
- HPREDICT
- IPREVMEMBER
- JPROPERTIES
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#MDX#PARALLELPERIOD#time intelligence#calculated measures