Cousin

Return to: Calculated Member Builder Function List

Returns the member with the same relative position under a member as the member specified.

Syntax

Cousin(«Member1», «Member2»)

Remarks

This function operates on the position of members within levels. In the example below it is assumed that both years 1996 and 1994 contain the same number of months preceding the member March. However, if 1996 contained the members January, February, March, and so forth, and 1994 contained the members January, March, April, and so forth, then the example would return [1994].April because it is in the same relative position (third) within the year.

Example

Cousin([1996].March, [1994])

This example yields the member [1994].March.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.