Export (0) Print
Expand All

ParallelPeriod

SQL Server 2000

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.

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].


Show:
© 2014 Microsoft