LastSibling (MDX)

Returns the last sibling of the specified member. Equivalent to: member.Parent.LasChild.

In our example, the last month of 2010, [Dec 2010].

Query

[Time].[May 2010].LastSibling

Result

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

Assertion : MDX Equals

[Time].[May 2010].Parent.LastChild

Assertion : MDX Equals

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

If the member has no parent, returns the last member of the level of the specified member. Equivalent to: Tail( member.Level.Members ).

In our example, the last year.

Query

[Time].[2010].LastSibling

Result

{ 
  [Time].[Calendar].[Year].[2011]
}

Assertion : MDX Equals

Tail( [Time].[2010].Level.Members )

Returns NULL if applied to a NULL entity.

Query

NULL.LastSibling

Result

NULL

Using an invalid parameter type causes an error.

Query

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

Result

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

Using an invalid parameter type causes an error.

Query

[Geography].[Geo].[Continent].LastSibling

Result

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

Using an invalid parameter type causes an error.

Query

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

Result

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

Using an invalid parameter type causes an error.

Query

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

Result

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

Using an invalid parameter type causes an error.

Query

"hello".LastSibling

Result

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