Insert Progress status in TI process

Post Reply
pikolikoli
Posts: 38
Joined: Sun May 17, 2020 2:37 am
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Insert Progress status in TI process

Post by pikolikoli »

Hi TM1ers,

I need to add status displaying the start and the end of a TI process.

I know that TI processes don't commit its data until the end of the process.

So I opted of another solution. I created a parent process, where I added a cellputS to my new logging cube( with status ' Running'). Then I called my original process using RunProcess.

Somehow, the cellputS didnt work even though both processes need to run in parallele. Any idea why ?

I switched now to using attributes, and it worked for me. The 'Running' status is added at the start.

I am writting this process so I can understand why CellputS didnt work but the attribute insertion worked?

Also, I would love if there is any better solution to go with ?

Thanks
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Insert Progress status in TI process

Post by BariAbdul »

Hi, below discussion might help. try to use asynchronous function, which CellputS is not actually.

https://www.tm1forum.com/viewtopic.php?t=14850 Thank you.
"You Never Fail Until You Stop Trying......"
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Insert Progress status in TI process

Post by qml »

If your status cube is small (which it typically is) then one way to commit value changes done via CellPutN/CellPutS in it right away is to invoke CubeSaveData() on that cube, which commits data mid-process and serialises the cube to disk.
Normally data is committed only at the end of the transaction i.e. at the end of the parent process.
Kamil Arendt
Post Reply