docs.intersystems.com
InterSystems IRIS Data Platform 2019.2  /  InterSystems MDX Reference  /  MDX Functions

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


Returns the last sibling of the given member.
Returned Type
This function returns a member.
Syntax and Details
member_expression.LASTSIBLING 
Where:
This function examines all the children of the parent of the given member, and returns the last member of that set (considering the default order of that set).
This function can return the same member that you use as its argument (if that is the last sibling).
Example
For example:
SELECT MEASURES.[%COUNT] ON 0, birthd.[Mar 2003].LASTSIBLING ON 1 FROM patients
 
                             Patient Count
Dec-2003                                17
See Also


Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-10-14 06:57:36