Returns the range of tuples between (and inclusive of) two tuples at the same level.
The range is created by identifying the level of the arguments and pruning the result set to include only the argument tuples and the tuples that are, in terms of outline order, between them.
Syntax
TupleRange ( tuple1, tuple2 )
Parameter | Description |
---|---|
tuple1 | The first input tuple, marking the beginning of the range. |
tuple2 | The second input tuple, marking the end of the range. |
Notes
TupleRange serves the same purpose as the @XRANGE function in the Essbase calculator language.
The two input tuples must be of the same dimensionality. See the example, wherein both input tuples are of the format ([Year],[Month]).
Example
TupleRange can be useful if you have two Time dimensions. For example, the following expression averages a value for the range of months from Mar 2005 to Feb 2006, inclusive.
AVG ( TUPLERANGE( ([2005], [Mar]), ([2006], [Feb]) ) )
The values are averaged for the following range:
{([2005], [Mar]), ([2005], [Apr]), ([2005], [May]), ([2005], [Jun]), ([2005], [Jul]), ([2005], [Aug]), ([2005], [Sep]), ([2005], [Oct]), ([2005], [Nov]), ([2005], [Dec]), ([2006], [Jan]), ([2006], [Feb])}