TM1 Forum

Hi All,

I am trying to capture chore timing start and end time for a particular. I am currently copying log details in MS excell and then finding out the start and end of chore timing.
Is there better way get this done- MS excell macro?

Please advise
Ravi

ravi wrote: I am trying to capture chore timing start and end time for a particular. I am currently copying log details in MS excell and then finding out the start and end of chore timing.
Is there better way get this done- MS excell macro?

"Better" is arguable and probably comes down to opinion and personal preference as much as anything else. You could write some code to automatically parse the server log.

Personally I just have a control cube which has elements for each chore and elements for the various parameters, inputs and outputs of the chores. I write the start time into the control cube at the start and the end time in as the last thing in the Epilog. Since I generally use a master process these days (for new chores, not ones that have carried forward from our old 8.2.12 days but those will be rewritten in time) I can also calculate and write the time elapsed into a further element.

Granted that method stores only the start/end/run times of the most current run in the control cube, but I find querying the transaction logs to get past ones to be vastly easier than wading through the vast swampland of irrelevant bumpf that clogs up the server log.