Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

ParallelPeriod

Returns a member from a prior period in the same relative position as a specified member.

Syntax

ParallelPeriod([«Level»[, «Numeric Expression»[, «Member»]]])

Remarks

This function is similar to the Cousin function, but is more closely related to time series. It takes the ancestor of «Member» at «Level» (call it ancestor); then it takes the sibling of ancestor that lags by «Numeric Expression», and returns the parallel period of «Member» among the descendants of that sibling.

This function has the following defaults:

This function is equivalent to Cousin(Member,Lag(Ancestor(Member,Level),Numeric Expression).

Example

The following table lists different examples of how you can use this function.

Expression Returns
ParallelPeriod(Year,2, 
[96 Qtr 3])
[94 Qtr 3]
ParallelPeriod(Year,2)
The parallel period of Time.CurrentMember, two years ago.

That is, if Time.CurrentMember is [1993June], the returned member is [1991June].

ParallelPeriod(Year)
The parallel period of Time.CurrentMember from last year.

That is, if Time.CurrentMember is [1993June], the returned member is [1992June].

ParallelPeriod()
The parallel period in the immediately prior sibling to the parent of Time.CurrentMember.

For example, if Time.CurrentMember is [1993June], the returned member is [1993March]. The parent of ([1993June] is Quarter2, whose immediately prior sibling is Quarter1, in which the parallel period is [1993March].