IsSibling

Returns TRUE if the first member is a sibling of the second member.

Syntax

IsSibling( member1, member2 )

member1 A member specification.
member2 A member specification.

Example

The following query returns all Market dimension members for which the expression IsSibling([Market].CurrentMember, [California]) returns TRUE; in other words, the query returns all states that are siblings of California.

SELECT
 Filter([Market].Members, IsSibling([Market].CurrentMember, [California]))
ON COLUMNS
FROM Sample.Basic
California Oregon Washington Utah Nevada
12964 5062 4641 3155 4039

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com