CHILDREN (MDX)
Returns a set that contains the children, if any, of a specified member.
Returned Type
Syntax and Details
member_expression.CHILDREN
Where:
-
member_expression is an expression that returns a member.
This expression cannot refer to a measure.
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
