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.
Log in to post a comment.