Returns TRUE if the first member is a sibling of the second member and, optionally, if the first member is equal to the second member.
Syntax
IsSibling( member1, member2 [, INCLUDEMEMBER])
Parameter | Description |
---|---|
A member specification. | |
A member specification. | |
INCLUDEMEMBER | Optional. Use this keyword if you want IsSibling to return TRUE if the first member is equal to the second member. |
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
Oregon | Washington | Utah | Nevada |
---|---|---|---|
5062 | 4641 | 3155 | 4039 |
The following query is the same as the above query, except that it uses INCLUDEMEMBER. It 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, including California itself.
SELECT Filter([Market].Members, IsSibling([Market].CurrentMember, [California], INCLUDEMEMBER)) ON COLUMNS FROM Sample.Basic
California | Oregon | Washington | Utah | Nevada |
---|---|---|---|---|
12964 | 5062 | 4641 | 3155 | 4039 |