Parallel Period

The Parallel Period functions return a member from a previous period in the same level as the given member. For instance, if a Parallel Quarter calculation is selected, and the given date is Q2 2010, then Q2 2009 is returned.

Parallel Period functions return:

  • A parameter, which is used to inject a date into the query at runtime.
  • Custom lists, which return a list of dates when added to the query (the parallel period).

Note: the Parallel Period functions are supported by user hierarchies in MS OLAP, Tabular, and BW data models only.