ParallelPeriod

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:

• Default «Member» value is Time.CurrentMember if «Level» is not specified. Otherwise it is dimension.CurrentMember, where dimension is the dimension to which level belongs.
  
  
• Default «Numeric Expression» is 1.
  
  
• Default «Level» is the level of the parent of «Member».

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.

ParallelPeriod(Year,2, 
[96 Qtr 3])

[94 Qtr 3]

ParallelPeriod(Year,2)

ParallelPeriod(Year)

ParallelPeriod()