TM1 Forum

Posted: **Fri May 16, 2014 1:50 pm**

As the beginner i'm traying to solve the follwing issue in TI:
The imported % data is set up as whole number in the source file (25, 35, ...). When imported to the cube, where format is set for %, these data becomes 2500%, 3500% (inested of 25%, 35%). My idea is to divide imported data by 1000 in TI porcess, however I cannot find on he net any scrpits how to do it. Could anyone show me the scrpt to divide imported data before getting into the cube ? Thanks a lot for your help

Posted: **Fri May 16, 2014 1:54 pm**

adasko wrote:As the beginner i'm traying to solve the follwing issue in TI:
The imported % data is set up as whole number in the source file (25, 35, ...). When imported to the cube, where format is set for %, these data becomes 2500%, 3500% (inested of 25%, 35%). My idea is to divide imported data by 1000 in TI porcess, however I cannot find on he net any scrpits how to do it. Could anyone show me the scrpt to divide imported data before getting into the cube ? Thanks a lot for your help

First things first I think you want to divide by 100 not 1000.

In the event that your variables tab shows the value from source as vValue and your dimension variables are called v1, v2 etc for subsequent dimensions.

Code: Select all


nValuePercentage = vValue \ 100;

CellPutN ( nValuePercentage, sCub, v1, v2, ... 'Measure' );

If you are using the wizard to create your TI processes you can also create another variable manually and assign the calculation to that in the variables formula tab.

Posted: **Fri May 16, 2014 2:28 pm**

You're right. Thanks a lot

TM1 Forum

Arithmetics in TurboIntegrator

Arithmetics in TurboIntegrator

Re: Arithmetics in TurboIntegrator

Re: Arithmetics in TurboIntegrator