Product:

Planning Analytics 2.0.9.18

Issue:

How create a simple check on input values in a TI process?

Solution:

Ad a IF statement in the PROLOG tab that check the input values against size, simplest to ensure the values entered is real – keep the size correct.

You have parameters the user should enter, then you need to do some simple check that the values entered are realistic.

ProcessQuit will terminate that process. Metadata and Data will not be executed.

ProcessBreak will stop processing the source and proceed directly to the Epilog tab (without returning an error handle to the TI).

More Information:

https://www.wimgielis.com/tm1_break_EN.htm 

https://exploringtm1.com/processquit-tm1-command-use-and-syntax/ 

https://exploringtm1.com/itemreject-tm1-function-syntax-use/ 

This example is simply checking if an element entered into a parameter exists in a dimension using a DIMIX and if it doesn’t, it puts a message in the log and quits the process.

IF ( DIMIX ( 'Location', pLocation) = 0);
sErrorMessage = 'The Location entered does not exist';
ItemReject ( sErrorMessage );
ENDIF;

https://www.ibm.com/docs/en/cognos-tm1/10.2.2?topic=basics-string-length-limit-in-turbointegrator#StringLengthLimitinTurboIntegrator_NB5009
https://code.cubewise.com/blog/tm1-hidden-features