fbpx

Tail (MDX)

Returns the last 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 end of the specified set.

If no numeric expression is specified the last element of the set will be returned.

If the specified number of elements is less than 1, an empty set will be returned.

See Also

Head Subset Range

Examples

Special Examples (errors, null, ...)

XMLA Properties

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