fbpx

Head (MDX)

Returns the first specified number of elements in a set.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  numeric-expression  zero-one 

Return

set

Description

Returns a set containing the specified number of the elements from the start of the set.

If no numeric expression is specified the first element of the set is returned.

If the specified number of elements is greater than the size of the initial set then the original
set will be returned.

See Also

Tail Subset Range

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.