LASTCHILD
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
See Also
Purpose of this instance: Draft documentation
DocReleaseID: Core2018.1.11
Content loaded from:
/staging/ce/2018.1.11/doc/cache/en-us/src/
/staging/ce/2018.1.11/doc/ensemble/en-us/src/
/staging/ce/2018.1.11/doc/isp/en-us/src/
/staging/learning/zenmojo-doc/en-us/src/