nerdexam
Microsoft

70-466 · Question #147

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…

The correct answer is D. PARALLELPERIOD(). The MDX PARALLELPERIOD function returns a member from a prior period at the same relative position in its level hierarchy, making it the correct choice for year-over-year and month-over-month calculations.

Build an analysis services database

Question

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?

Options

  • AUNREGINTERCEPT()
  • BLASTPERIODS()
  • CTIMEINTELLIGENCE()
  • DPARALLELPERIOD()

How the community answered

(43 responses)
  • A
    2% (1)
  • B
    7% (3)
  • C
    2% (1)
  • D
    88% (38)

Why each option

The MDX PARALLELPERIOD function returns a member from a prior period at the same relative position in its level hierarchy, making it the correct choice for year-over-year and month-over-month calculations.

AUNREGINTERCEPT()

UNREGINTERCEPT is not a valid MDX function; it does not exist in the MDX specification and would cause a query error.

BLASTPERIODS()

LASTPERIODS returns a set of consecutive members ending at a specified member and is used for rolling period totals, not for referencing a single parallel period for comparison.

CTIMEINTELLIGENCE()

TIMEINTELLIGENCE is not a native MDX function; it refers to a general feature concept in SSAS and is not a callable expression in MDX queries.

DPARALLELPERIOD()Correct

PARALLELPERIOD navigates up the time hierarchy to a specified ancestor level, then moves back a given number of periods, and returns the descendant at the same relative position as the original member. This behavior directly enables YOY comparisons (move back one year) and MOM comparisons (move back one month) by referencing the parallel member in the prior period. It is the standard MDX function used in SSAS cube calculations for period-over-period time intelligence.

Concept tested: MDX PARALLELPERIOD for period-over-period time calculations

Source: https://learn.microsoft.com/en-us/sql/mdx/parallelperiod-mdx

Topics

#MDX#PARALLELPERIOD#time intelligence#YOY calculation

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice