Which Multidimensional Expressions (MDX) function should you use?

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?

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()



Leave a Reply 3

Your email address will not be published. Required fields are marked *