Hi, I would like to store cube start date, time and end date, time from cube build log file into a database table or csv file on daily basis. We would like to analyze the history of cube build times by cube and date over a period of time.
Anyone has any suggestions? Your help is highly appreciated.
Although I don't know of any direct way, but the way we have implemented is by adding small pieces of codes in our scripts to add a record at the end of the builds which stores the start and end times, along with the exit status. To make the task easier, we basically created a generic cube build script which would store these information.
Another alternative is, if you are using Oracle 9i or later, to create an external table and copy the log files to the source of this table. But it may require a lot of cleanup and maintenance as well.
--Javed
There's a document in the Cognos Knowledge Base called "Practical Guide to Transformer in Production". Sorry I don't have a link to it.
It contains a chapter on working with the Transformer log, suggesting an import to spreadsheet and sorting on log categories.
As suggested there's nothing built in to do this, pull what you need out of the log file after the fact with your preferred scriptable tool and insert it into a homegrown database table.