Skip to main content

Children

Returns a naturally ordered set that contains the children of a specified member. For use with an aggregate function, i.e. SUM(Descendants(...), Measure). If the specified member has no children, this function returns an empty set.

Syntax​

Member_Expression.Children

Input Parameters​

Member_Expression (Required)
A valid Multidimensional Expressions (MDX) expression that returns a member.

Return Value​

Returns a Set of Members.

Example​

Sum the Distinct Customer Count Estimate ([[Measures].[customercountestimate1]) of the current member's children.

SUM([DateCustom].[Retail445].currentMember.children, [Measures].[customercountestimate1])