LastSibling (MDX)

Returns the last child of the parent of a specified member.

Syntax

Member_Expression.LastSibling 

Arguments

• Member_Expression
  A valid Multidimensional Expressions (MDX) expression that returns a member.

Example

The following example returns the default measure for the last quarter in fiscal year 2004.

SELECT [Date].[Fiscal].[Fiscal Year].
   [FY 2004].LastChild.LastChild.LastSibling 
   ON 0
FROM [Adventure Works]

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History