Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.4 / Analytics / InterSystems MDX Reference / MDX Functions / SIBLINGS
Previous section   Next section

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

Previous section   Next section