Accumulate function in TI process.

Post Reply
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Accumulate function in TI process.

Post 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.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Accumulate function in TI process.

Post by jim wood »

CellPutN(CellGetN()+Value,.....). If you use the GUI to auto generate the formula for you you'll get the same result.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Accumulate function in TI process.

Post by Michel Zijlema »

Or CellIncrementN(Value, cube, dim1, ..., dimn) if you're on TM1 10.x.

Michel
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Accumulate function in TI process.

Post by dilip »

Thank you very Much I got it.
Post Reply