Returns TRUE if the first member is a sibling of the second member.
IsSibling( member1, member2 )
member1 | A member specification. |
member2 | A member specification. |
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 |