Head

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

Syntax

Head(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 beginning of a set, in their original order.

Example

The following expression returns the first six tuples from the specified set:

Head( Descendants( [DateCustom].[StandardMonth].CurrentMember, [DateCustom].[StandardMonth].[Month] ), 6 )