IsSibling

The MDX IsSibling function for Essbase 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])

Parameters

member1: A member specification.
member2: 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 1

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

The above query returns the following output:

Table 4-96 Output Grid from MDX Example

Oregon	Washington	Utah	Nevada
5062	4641	3155	4039

Example 2

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

The above query returns the following output:

Table 4-97 Output Grid from MDX Example

California	Oregon	Washington	Utah	Nevada
12964	5062	4641	3155	4039