CellIncrementN and BatchUpdate Mode

Post bug reports and the status of reported bugs
Post Reply
User avatar
Posts: 704
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016

CellIncrementN and BatchUpdate Mode

Post by paulsimon » Fri Jun 20, 2014 6:27 pm


I have just found an issue whereby CellIncrementN when you are in BatchUpdate Mode works like CellPutN

This is present in at least versions 10.2 IF1 and 10.2 FP1 IF1.

This has been reported to IBM.


Paul Simon

Duncan P
Posts: 588
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: CellIncrementN and BatchUpdate Mode

Post by Duncan P » Sun Jun 22, 2014 2:18 pm

I'm not sure that I would have accepted that as a bug if I had been IBM, given that the stated behaviour of BatchUpdateMode is that values written to cells are not available to the TI until the transaction is committed, so you would always be incrementing the value that was there at the start of the transaction.

Is that in fact what is happening? If the TI starts with a value in the cell, is the value at the end the last value applied or is it the sum of the original value and the last value applied?

Community Contributor
Posts: 328
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: CellIncrementN and BatchUpdate Mode

Post by mvaspal » Fri Jun 27, 2014 8:44 am

I just wanted to report this bug to the forum when I saw Paul had already done so, I ran into this just today.

Why I would think this is a bug is that batch update mode works fine with the old logic:
vOldValue = CellGetN(...
CellPutN(Value + vOldValue , ...

I would expect the CellIncrementN should do the same.

Posts: 169
Joined: Fri Dec 10, 2010 4:07 pm
OLAP Product: TM1
Version: [2.x ...] 11.4.x / PAL 2.0.6
Excel Version: Excel 2010-2013
Location: Germany

Re: CellIncrementN and BatchUpdate Mode

Post by Gabor » Fri Jun 27, 2014 9:46 am

I thought it is more or less the TI version of the deferred update in the GUI, a kind of ancestor of sandboxing giving a private version of a cube structure without consolidations & rules. N-element values should be accessible at that time.

Post Reply