Children (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the set of children of a specified member.

Syntax


Member_Expression.Children  

Arguments

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

Remarks

The Children function returns a naturally ordered set that contains the children of a specified member. If the specified member has no children, this function returns an empty set.

Example

The following example returns the children of the United States member of the Geography hierarchy in the Geography dimension.

SELECT [Geography].[Geography].[Country].&[United States].Children ON 0  
FROM [Adventure Works]  

The following example returns all members in the Measures dimension on the column axis, this includes all calculated members, and the set of all children of the [Product].[Model Name] attribute hierarchy on the row axis from the Adventure Works cube.

SELECT  
    Measures.AllMembers ON COLUMNS,  
    [Product].[Model Name].Children ON ROWS  
FROM  
    [Adventure Works]  
Release History
17 July 2006 Changed content:
— Updated syntax and arguments to improve clarity.

— Added updated examples.

See Also

MDX Function Reference (MDX)