Expressions: Derived Cube - CubeCellHeader

You can use the CubeCellHeader function to reference a dimension’s category code or description as a string. Because a Cube can only return a numeric value, the CubeCellHeader function cannot be the outermost in the Expression and is likely to be used in conjunction with an IF or CASE statement to do a different calculation based on the code or description of the dimension value.

The above example demonstrates how to create a reference year from the Banded Booking Date (Months) dimension which might then be used to carry out more complex analysis, such as weighting the average cost of a holiday booking relative to a particular year. Note that StrNumber is used so that we can display this in our Cube.

 

Click to return to Expressions: Derived Cube