Home / InterSystems MDX Reference / MDX Functions / FIRSTSIBLING

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

Returns the first sibling of the given member.
Returned Type
This function returns a member.
Syntax and Details
This function examines all the children of the parent of the given member, and returns the first member of that set (considering the default order of that set).
This function can return the same member that you specify as an argument (if that member is the first sibling).
For example:
SELECT MEASURES.[%COUNT] ON 0, birthd.[Mar 2003].FIRSTSIBLING ON 1 FROM patients
                             Patient Count
Jan-2003                                10
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