Using the DimensionCreate Function to Create a Dimension in TM1

Often we will want to create dimensions in TM1. We might be creating a new model or recreating a dimension during a TI process. To do this we use the DimensionCreate function (not the CreateDimension function that doesn’t exist!).

Syntax of DimensionCreate

The syntax is DimensionCreate ( DimName );

where DimName represents the name of the dimension you want to create.

Example

DimensionCreate ( ‘Customer’ );

This example creates the Customer dimension in our TM1 model.

Usage

This function is often used in conjunction with an IF statement and the DimensionExists function to check if a dimension exists and if it doesn’t, then to create it. 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.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink.