TM1 Forum

TI process copies data from one cube to another.

It only contains in Data
CellPutN(NVALUE, 'Payments_Versions',months_cons,Numbers,Items,CFO,OMS_total,Version);

I notice such thing. When I start TM1 server and launch this process first time it takes 5 minutes from start to finish. When I launch it second time duration lessen drastically. It takes only several seconds.

It seems Cube-source loads in memory during first time and owing to it the second time duration lasts less time.

So is my guess right? And if so what can I do for loading cube-source in memory during starting of TM1 server?

EP_explorer wrote:TI process copies data from one cube to another.

It only contains in Data
CellPutN(NVALUE, 'Payments_Versions',months_cons,Numbers,Items,CFO,OMS_total,Version);

I notice such thing. When I start TM1 server and launch this process first time it takes 5 minutes from start to finish. When I launch it second time duration lessen drastically. It takes only several seconds.

It seems Cube-source loads in memory during first time and owing to it the second time duration lasts less time.

So is my guess right? And if so what can I do for loading cube-source in memory during starting of TM1 server?

Yes that's exactly right, it is faster the 2nd time because the rule calculated values are now cached and do not need to be re-evaluated. This will be the case provided there is no intermediate data change to the cube or any cube it has a dependency on. To pre-calculate before running the process review posts on using the ViewConstruct function.