Sometimes we need to check if a dimension exists in a Turbo Integrator process. We might want to then build it if it doesn’t exist or unwind the dimension if it does.  To do this is really easy with a simple function – DimensionExists.

Syntax of DimensionExists

DimensionExists ( DimName );

where DimName is the name of the dimension you want to check if it exists.

The function will return a “1” if it does exist or a “0” if it doesn’t.

Example

DimensionExists ( ‘Customer’ ) ;

This example determines if the Customer dimension exists in the current TM1 model and if it does, will return a 1.

Usage

It is often used in conjunction with an IF function and possibly DimensionCreate. This could look like:

sDimName = 'Customer' ;
IF ( DimensionExists ( sDimName ) = 0 ) ;
  DimensionCreate ( sDimName ) ;
ENDIF ;

In this example we are setting the variable sDimName as ‘Customer’, then testing if it exists and if not, then creating it.

You can only use this function in TI processes.