Parent (MDX)

Returns the parent of the member.

In our example, the parent of [Canada] which is [America].

Query

[Geography].[Geo].[Canada].Parent

Result

{ 
  [Geography].[Geo].[Continent].[America]
}

Assertion : MDX Equals

[Geography].[Geo].[America]

Assertion : MDX Equals

Ancestor([Geography].[Geo].[Canada],1)

Returns a null entity if the member has no parent (it is a root member).

Query

[Geography].[Geo].[All Regions].Parent

Result

NULL

Returns NULL if the member is a NULL entity.

Query

WITH
    MEMBER [Measures].[isNull] AS IIF( null.parent IS NULL, true, false )
SELECT
    [Measures].[isNull] ON 0
FROM
    [Sales]

Result

Assertion : Cell Equals

WITH
    MEMBER [Measures].[True] AS true
SELECT
    [Measures].[True] ON 0
FROM
    [Sales]

Returns an error if applied to an invalid type.

Query

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

Result

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

Returns an error if applied to an invalid type.

Query

[Geography].[Geo].[Continent].Parent

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Parent() : 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]}.Parent

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Parent() : 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])}.Parent

Result

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

Returns an error if applied to an invalid type.

Query

"hello".Parent

Result

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