Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions page (login required).

LASTSIBLING

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
Copy code to clipboard

See Also

Feedback