Producing a Transaction Log Report

[LanceTylor]

Hi All,

I wanted to find out how people tend to produce reports off the Transaction Log text files (tm1s.log)? Or if people do?

My client would a like an audit trial of any changes made post-budget sign off (1000 transactions max). They would like a report that contains the following Users/Client, CostCentre(dim), Account (dim), Before and After Values, Time, Total Opening/Closing Budget Balance and additional commentary explaining the change. Majority of this information is within the transaction log all other info will be sourced from relevant cubes.

Here is the options I have been thinking about thus far
1. Load Logs into DB Table and produce a BI Report (BI Report would have to be exported to BI to add Commentary) - Not a very nice business process
2. Load Logs into DB Table, From Table load transactions into a Transactions Reporting Cube and report in Perspectives (or BI potentially) - Longer process but allows administrators to enter commentary
3. Using TI (and advanced scripting?) load transactions logs through TI into a Tm1 Cube and report in Perspectives (or potentially BI) - Shorter process but the challenge (in my case, as this is the first time I have encountered this) is creating TI (or another form of scripting) to load in multiple log files with changing files names (timestamps)

As always, I appreciate any feedback or alternative suggestions

Lance

[LanceTylor]

Forgot to mention we are using Tm1 10.1.1 FP1

[EvgenyT]

Hello Mate,

Have you considered using AuditLog? Just a thought

Thanks

ET

[Duncan P]

I did some log-file processing some time ago for a "differential publish" to relation data-warehouse. However it never got used.

This is the code to walk the existing logs.

Code: Select all

SaveDataAll;
LASTLOGFILE = CellGetS( 'ProcessLogsHistory', 'Dummy', 'Last Log File' );
LATESTFILE = LASTLOGFILE;
LOGFILENAME = WildcardFileSearch( 'tm1s2*.log', '');
WHILE ( LOGFILENAME @<> '' );
   IF ( LOGFILENAME @> LASTLOGFILE );
      IF ( LOGFILENAME @> LATESTFILE );
         LATESTFILE = LOGFILENAME;
      ENDIF;
      ExecuteProcess( 'ProcessLogFile', 'LOGFILENAME', LOGFILENAME );
   ENDIF;
   LOGFILENAME = WildcardFileSearch( 'tm1s2*.log', LOGFILENAME);
END;
IF ( LOGFILENAME @<> LATESTFILE );
   CellPutS( LATESTFILE, 'ProcessLogsHistory', 'Dummy', 'Last Log File' );
ENDIF;

[LanceTylor]

Thanks for the responses.

ET - The audit log doesn't contain the information I require. I just need changes in cube values.

Duncan P - Thanks for the script...this should definitely come in handy.

Lance