Skip to main content
Previous section   Next section

CHILDREN

Returns a set that contains the children, if any, of a specified member.

Returned Type

This function returns a set of members.

Syntax and Details

member_expression.CHILDREN

Where:

If the specified member has no children, this function returns an empty set.

Example

For example:

SELECT MEASURES.[%COUNT] ON 0, birthd.[1960s].CHILDREN ON 1 FROM patients
                             Patient Count
 1 1960                                 105
 2 1961                                 153
 3 1962                                 144
 4 1963                                 153
 5 1964                                 136
 6 1965                                 149
 7 1966                                 187
 8 1967                                 159
 9 1968                                 169
10 1969                                 145
Copy code to clipboard

See Also