Returns the first child of the given member.
This function returns a member.
Syntax and Details
FeedbackOpens in a new tab
member_expression is an expression that returns a member.
This expression cannot refer to a measure.
The function returns the first child of this member. To determine which child is first, the function considers the default order of the set of children.
For example, consider the following hierarchy:
Now consider the following query:
SELECT MEASURES.[%COUNT] ON 0, homed.zip..FIRSTCHILD ON 1 FROM patients Patient Count Cypress 1,089
For another example:
SELECT MEASURES.[%COUNT] ON 0, birthd.1960.FIRSTCHILD ON 1 FROM patients Patient Count Jan-1960 5