member_expression.FIRSTCHILD
Where:
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.
Example
For example, consider the following hierarchy:
Now consider the following query:
SELECT MEASURES.[%COUNT] ON 0, homed.zip.[34577].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
See Also