Skip to main content
Version: I2025.4.x

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 )