CHILDREN (MDX) Contents Returned Type Syntax and Details Example See Also 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: 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 See Also ANCESTOR COUSIN DESCENDANTS FIRSTCHILD FIRSTSIBLING LASTCHILD LASTSIBLING PARENT SIBLINGS
