Page 1 of 1

Accumulate function in TI process.

Posted: Wed Aug 07, 2013 7:51 pm
by dilip
Is there any function in TI process to accumulate the values in tm1.I want only function so that we can manually write in TI process.

CellputN updates the values in TM1 if for the same record the value is coming. i want the values to addup through TI process. I dont want to select the option given in the mapping option.

I am unable to find the right function.Please suggest.

Re: Accumulate function in TI process.

Posted: Wed Aug 07, 2013 7:55 pm
by jim wood
CellPutN(CellGetN()+Value,.....). If you use the GUI to auto generate the formula for you you'll get the same result.

Re: Accumulate function in TI process.

Posted: Wed Aug 07, 2013 8:19 pm
by Michel Zijlema
Or CellIncrementN(Value, cube, dim1, ..., dimn) if you're on TM1 10.x.

Michel

Re: Accumulate function in TI process.

Posted: Wed Aug 07, 2013 8:20 pm
by dilip
Thank you very Much I got it.