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