icCube

Documentation

Range (MDX+)

Returns the set that is a subset of parameter set, starting at the second member's parameter till the third one.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  tuple-expression  one   
  tuple-expression  one   

Return

set

Description

If the parameters are defined as set1, tuple1 and tuple2 :

if both tuples are defined, a subset of set1 starting at tuple1 and ending at tuple2 (both included)
if tuple1 is null, a subset of set1 ending at tuple2 (included)
if tuple2 is null, a subset of set1 starting at tuple1 till the end.
if both tuple are null, set1.

This is similar to the Range operator in MDX, :.

See Also

Head Tail Subset

Examples

Special Examples (errors, null, ...)

Since Version

6.8.6

XMLA Properties

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