FirstSibling (MDX)

Returns the first sibling of the member.

Equivalent to Parent.FirstChild.

Query

[Time].[May 2010].FirstSibling

Result

{ 
  [Time].[Calendar].[Month].[Apr 2010]
}

Assertion : MDX Equals

[Time].[May 2010].Parent.FirstChild

Assertion : MDX Equals

Head([Time].[May 2010].Parent.Children)

Returns NULL if applied to a NULL entity.

Query

NULL.FirstSibling

Result

NULL

Using invalid parameter type causes an error.

Query

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

Result

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

Using invalid parameter type causes an error.

Query

[Geography].[Geo].[Continent].FirstSibling

Result

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

Using invalid parameter type causes an error.

Query

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

Result

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

Using invalid parameter type causes an error.

Query

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

Result

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

Using invalid parameter type causes an error.

Query

"hello".FirstSibling

Result

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