Learning
Community
Open Exchange
Global Masters
InterSystems IRIS Data Platform 2019.3 / Application Development / InterSystems MDX Reference / MDX Functions / CHILDREN
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

See Also

Previous section   Next section