TM1 Forum

Looking to record when a TI process starts and ends in a Process Log Cube. Ive created a variable for each

vStarted = TIMST(NOW,'\D_\M_\Y_\h_\i_\s'); I have put into the Prolog tab and then done a CellPutS to a Log cube

vEnded= TIMST(NOW,'\D_\M_\Y_\h_\i_\s'); I have put in the Epilog tab and again done a CellPutS to a log cube

All seems to work fine apart from fact that both Start and End times are exactly the same, and although I am not loading a lot of data in the TI i would expect it to take more than a second to execute successfully ? Have I got the variables in the right place ?

Also Id like to have some sort of status flag for the process along the lines of 'Completed', 'Error' or something similar, has anybody done something similar ?

Thanks as always for any help.

Have you looked in the actual server log file to see the timestamps for process executed and process completed to see how long they take to complete?

http://www.bihints.com/monitoring_chore ... ail_part_2

prob you can do something like the above tutorial.

A document that will give you a few ideas.
http://www.ibm.com/developerworks/data/ ... ge328.html


Cheers

The 2 links you've been given above are pretty good and I think about all you need to build your own process logging solution. Depending on the number of records you are processing I wouldn't be too surprised if start time and finish time were the exact same second considering that TI should processes multiple thousand records per second.

Some great responses as always.

The two links provided were excellent and provided some useful techniques.

And you were all write as well, the process I was testing did indeed take only a second to run.

Thanks.