PrepAway - Latest Free Exam Questions & Answers

Which Multidimensional Expressions (MDX) function shoul…

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?

PrepAway - Latest Free Exam Questions & Answers

A.
UNREGINTERCEPT()

B.
LASTPERIODS()

C.
TIMEINTELLIGENCE()

D.
PARALLELPERIOD()


Leave a Reply