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