LASTCHILD - DeepSee MDX Reference - Caché & Ensemble 2018.1

docs.intersystems.com

DeepSee MDX Reference

LASTCHILD

[Home] [Back] [Next]

InterSystems: The power behind what matters

InterSystems DeepSee > DeepSee MDX Reference > MDX Functions > LASTCHILD

Search:

Returns the last child of the given member.

Returned Type

This function returns a member.

Syntax and Details

member_expression.LASTCHILD

Where:

member_expression is an expression that returns a member.

This expression cannot refer to a measure.

The function returns the last child of this member. To determine which child is last, the function considers the default order of the set of children.

Example

For example:

SELECT MEASURES.[%COUNT] ON 0, homed.zip.[34577].LASTCHILD ON 1 FROM patients
 
                             Patient Count
Pine                                 1,100

To see a picture of the hierarchy used in this example, see the FIRSTCHILD function.

For another example:

SELECT MEASURES.[%COUNT] ON 0, birthd.[1950].LASTCHILD ON 1 FROM patients
                             Patient Count
Dec-1950                                  8