You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at
your company.
The sales department has the following requirements for the cube:
Include a year-over-year (YOY) calculation
Include a month-over-month (MOM) calculation
You need to ensure that the calculations are implemented in the cube.
Which Multidimensional Expressions (MDX) function should you use?
A.
UNREGINTERCEPT()
B.
LASTPER1ODS()
C.
TIMQNTELUGENCE()
D.
PARALLELPERIOD()
D
I agree.
ParallelPeriod is exactly YOY or MOM analysis
https://msdn.microsoft.com/en-us/library/ms145500.aspx
LASTPERIODS – you point to a period and the number of preceeding periods – like Oct 2015,3 what means Jul/August/Sept 2015
https://msdn.microsoft.com/en-us/library/ms145588.aspx