docs.intersystems.com
Home  /  Application Development: Analytics Options  /  InterSystems MDX Reference  /  MDX Functions  /  SIBLINGS


InterSystems MDX Reference
SIBLINGS
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


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