parallelPeriod

Returns a member from a prior period in the same relative position as "member". This function is similar to the cousin function, but is more closely related to time series. It takes the ancestor of "member" at "level" (called "ancestor") and the sibling of "ancestor" that lags by "integer_expression" positions, and returns the parallel period of "member" among the descendants of that sibling. When unspecified, "integer_expression" defaults to 1 and "member" defaults to the current member.

Syntax

parallelPeriod ( level [ , integer_expression [ , member ] ] )

Example 1

parallelPeriod ( [great_outdoors_company].[Years].[Years].[Quarter] ,
 -1 , [2006/Aug] )

Result

2006/Nov

Example 2

parallelPeriod ( [great_outdoors_company].[Years].[Years].[Quarter] ,
 1 , [2006/Aug] )

Result

2006/May

Example 3

parallelPeriod ( [great_outdoors_company].[Years].[Years].[Year] , 2 ,
 [2006/Aug] )

Result

2004/Aug