TM1 Forum

Hello,

I have been trying to create the elapsed time in seconds that it would take an existing process to complete running (namely an overnight process). I know this is calculated within the Message Log, but I would like to put this in a control cube. Any Ideas on how to accomplish this within a process?

Thank you!

Are you saying you want to record how long it takes to run a process and store that value in a control cube? It would be easier to record the start and stop times in the control cube and then calculate the elapsed time via a rule in the control cube. Just CellPutN the value from the NOW() function into the starting time cell in control cube on the Prolog tab and then CellPutN the NOW() value in the ending time cell on the Epilog tab. I'll let you take a stab at writing the rule. Hint: Subtract the two dates and then use TIMST function to format as desired.

At the beginning of Prolog add this line: At the end of Epilog add this line: Then just write nElapsedSeconds to a cube and you're done. It will give you the execution time rounded to full seconds.