Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.4 / Analytics / InterSystems MDX Reference / MDX Functions / FIRSTSIBLING
Previous section   Next section

FIRSTSIBLING

Returns the first sibling of the given member.

Returned Type

This function returns a member.

Syntax and Details

member_expression.FIRSTSIBLING 
Where:
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).

Example

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