Transformer Log Audit

[ChillAPAC]

Does anyone have an automatic process to pull log file data and store it for analysis? I seem to remember somebody discussing using MS ACCESS? to pull log file data daily and store it so it's available for reporting.
I would like to pull the cube name data, time/date of refresh length of refresh in addition to individual iqd names, time/date and length of time each query took.
It would be helpful to view cube run times over time to determine bottlenecks, changes to source tables, network issues, etc.

Thanks in advance,

Bill

 

[RVLF]

you can dowload something for that on Cognos site

 

[Kaiaualad]

You can use the MS Access files that contain the Audit Data
to load an analysis cube with all the required headings you mentioned.

 

[ChillAPAC]

RVLF-
I've searched the Cognos site and come up empty. Do you have any further information on what to download from Cognos?

Thanks for your help!

Bill