Siblings (MDX)

Returns all siblings of the member including the member itself.

In our example, for [Geneva] we return all cities of [Switzerland].

Query

[Geography].[Geo].[Geneva].siblings

Result

{ 
  [Geography].[Geo].[City].[Geneva], 
  [Geography].[Geo].[City].[Lausanne], 
  [Geography].[Geo].[City].[Zurich]
}

Assertion : MDX Equals

[Geography].[Geo].[Geneva].Parent.Children

Return all siblings for [Europe]. As it is a root member, all the members of his level.

Query

[Geography].[Geo].[Europe].siblings

Result

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

Assertion : MDX Equals

[Geography].[Europe].level.members

Returns NULL if applied to a NULL entity.

Query

NULL.siblings

Result

{}

Returns an error if applied to an invalid type.

Query

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

Result

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

Returns an error if applied to an invalid type.

Query

[Geography].[Geo].[Continent].siblings

Result

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

Result

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

Result

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

Returns an error if applied to an invalid type.

Query

"hello".siblings

Result

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