Skip to main content

SIBLINGS

Returns a set that contains the specified member and all its siblings.

Returned Type

This function returns a set of members.

Syntax and Details

member_expression.SIBLINGS

Where:

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

FeedbackOpens in a new tab