Skip to main content
Version: I2023.2.1

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])