CUBEID

Syntax

CUBEID (Cube)

Description

The CUBEID function returns the internal ID of the cube in the analytic calculation engine. Note that the actual ID for the cube may vary in the analytic calculation engine when the model has been changed. For example, when a part is added or deleted. Do not use absolute numbers to compare the return of the CUBEID function. The CUBEID function may be useful if you have a generic user function and you want to pass different data cubes as expression arguments.

Returns

The internal ID of the cube in the analytic calculation engine.

Example

IF(CUBEID(@MyCube) = CUBEID(REVENUE), 
SPECIAL_CONDITION_CALCULATION, DEFAULT_CALCULATION)

This is an example of incorrect usage of the CUBEID function:

IF( CUBEID(@MYCUBE) = 512, 
SPECIAL_CONDITION, DEFAULT_CONDITION)