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
Examples
Special Examples (errors, null, ...)
Since Version
6.8.6
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.