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. LASTPERIODS()
C. TIMEINTELLIGENCE()
D. PARALLELPERIOD()
