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.
Accumulate function in TI process.
- 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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- 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.
Or CellIncrementN(Value, cube, dim1, ..., dimn) if you're on TM1 10.x.
Michel
Michel
-
- 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.
Thank you very Much I got it.