Children (MDX)

Returns the children of the member.

In our example all cities of Europe.

Query

[Geography].[Geo].[Europe].children

Result

{ 
  [Geography].[Geo].[Country].[France], 
  [Geography].[Geo].[Country].[Spain], 
  [Geography].[Geo].[Country].[Switzerland]
}

Assertion : MDX Equals

Descendants([Geography].[Geo].[Europe], 1)

Assertion : MDX Equals

// Filtering all the countries whose parent is Europe.
Filter( [Geography].[Geo].[Country].members , [Geography].[Geo].currentMember.parent IS [Geography].[Geo].[Europe] )

Children method returns members in their natural order (i.e., hierarchized).

Query

[Geography].[Geo].[Europe].children

Result

{ 
  [Geography].[Geo].[Country].[France], 
  [Geography].[Geo].[Country].[Spain], 
  [Geography].[Geo].[Country].[Switzerland]
}

Assertion : MDX Equals

Hierarchize([Geography].[Geo].[Europe].children)

Returns an empty set if the member has no children (it's a leaf member).

Query

[Geography].[Geo].[Paris].children

Result

{}

Calculated members are not included in children function.

Query

WITH
    MEMBER [Geography].[Europe].[Andorra] as 42
SELECT
    [Geography].[Europe].children on 0
FROM
    [Sales]

Result

Assertion : MDX Equals

SELECT
    [Geography].[Europe].children on 0
FROM
    [Sales]

Returns an empty set if applied to a NULL entity.

Query

[Geography].[Geo].[Paris].children

Result

{}

Returns an error if applied to an invalid type.

Query

([Geography].[Geo].[Spain],[Product].[Licence].[Personal]).children

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Children() : argument (0) type mismatch: expected:'member', got:'tuple'

Returns an error if applied to an invalid type.

Query

[Geography].[Geo].[Continent].children

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Children() : argument (0) type mismatch: expected:'member', got:'level'

Returns an error if applied to an invalid type.

Query

{[Geography].[Geo].[United States],[Geography].[Geo].[Switzerland],[Geography].[Geo].[Spain]}.children

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Children() : argument (0) type mismatch: expected:'member', got:'set'

Returns an error if applied to an invalid type.

Query

{([Geography].[Geo].[United States],[Product].[Licence].[Personal]),([Geography].[Geo].[Spain],[Product].[Licence].[Personal])}.children

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Children() : argument (0) type mismatch: expected:'member', got:'set'

Returns an error if applied to an invalid type.

Query

"hello".children

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Children() : argument (0) type mismatch: expected:'member', got:'string'