Expressions: Derived Cube - CubeCellIndex
This function adds a numeric reference to each category in the selected dimension. For example:
_623x22.png)
-
Create and name the Expression and then drag and drop it onto your Cube as a measure
Each category within the dimension has its own numeric reference:
.png)
These “CubeCellIndex” reference numbers can then be used to refer to categories in other Expressions – e.g. an IF statement:
_912x125.png)
The above Expression compares the value of each referenced cell (from cell reference 14) with that of cell reference 14 – i.e. January 2014. See ‘Comparison to Point in Time 1’ in the Cube below.
Alternatively:
_917x124.png)
This Expression compares the value of each referenced cell (backwards from cell reference 14) with that of cell reference 14 – i.e. January 2014. See ‘Comparison to Point in Time 2’ in the Cube below.
_814x524.png)
Note
Only the original referenced dimension is needed for the calculation. In the screenshot below, where Gender has been added as a second dimension on the Cube, you can see the numeric reference is the same for each gender category.
_1184x479.png)
Click to return to Expressions: Derived Cube