Home / InterSystems MDX Reference / MDX Functions / SIBLINGS

InterSystems MDX Reference
Previous section           Next section
InterSystems: The power behind what matters   

Returns a set that contains the specified member and all its siblings.
Returned Type
This function returns a set of members.
Syntax and Details
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
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-04-10 14:45:56