Product:

Cognos TM1 10.2.2

Windows 2008 R2 Server

 

Problem:

How create the measure dimension in a TI process?

And not use the TM1S.CFG parameter DefaultMeasureDimension=T

That will make the last dimension the measure dimension at every cube creation.

http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SS9RXT_10.1.0/com.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc/c_defaultmeasuresdimension_tm1.html%23DefaultMeasuresDimension_tm1

 

Solution:

Go into TM1 Architect and create a new TI process;

In PROLOG set some parameters for the cube.

#—————————–

# set default values

#——————————-

cCubeName = ‘IA.WLicensUsage’ ;

cDimParameter = ‘IA.WUsers’ ;

cDimMeasure=  ‘IA.WLicens’ ;

In EPILOG set this command

cellputs (cDimMeasure, ‘}CubeProperties’,cCubeName,’MEASURES_DIMENSION’);

 

Change the variables names to fit with your cube and dimensions names.