SIBLINGS (MDX)

Returned Type

This function returns a set of members.

Syntax and Details

member_expression.SIBLINGS

Where:

• member_expression is an expression that returns a member.

  This expression cannot refer to a measure.

Example

For example:

SELECT MEASURES.[%COUNT] ON 0, homed.cypress.SIBLINGS ON 1 FROM patients
 
                             Patient Count
1 Cypress                             1,089
2 Magnolia                            1,073
3 Pine                                1,039

To see a picture of the hierarchy used in this example, see the FIRSTCHILD function.

See Also

• CHILDREN

• COUSIN

• DESCENDANTS

• FIRSTCHILD

• FIRSTSIBLING

• LASTCHILD

• LASTSIBLING

• PARENT