Tail

Returns the specified number of tuples from the end of a set, in their original order.

Syntax

Tail(Set_Expression [ ,Count ] )

Input parameters

Set_Expression

An MDX expression that returns a set.

Count

The number of tuples to return. If no value is specified, one is returned.

Return value

The specified number of tuples from the end of a set, in their original order.

Example

The following expression returns the last three tuples from the end of the specified set:

Tail( Descendants( [DateCustom].[StandardMonth].CurrentMember, [DateCustom].[StandardMonth].[Month] ), 3 )