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

Release History

17 July 2006
Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
  • Last updated on