fbpx

Subset (MDX)

Returns subset of the original set in the specified range of elements.

Parameters

Name Type Cardinality Default value
  set-expression     
start-index  numeric-expression  one   
count  numeric-expression  zero-one  infinite 

Return

set

Description

Returns a set containing 'count' number of the elements beginning at start-index (first member is 0)

If the count parameter is not specified the subset starting from a specified index and going to the end of the specified set is returned.

If the count parameter is lower or equals to 0, an empty set will be returned.

See Also

Head Tail Range

Examples

Special Examples (errors, null, ...)

XMLA Properties

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