Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Children (MDX)

Returns the set of children of a specified member.



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

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.


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.

    Measures.AllMembers ON COLUMNS,
    [Product].[Model Name].Children ON ROWS
    [Adventure Works]



17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.

  • Added updated examples.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft