DeepSee MDX Reference
CHILDREN
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

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