Troubleshooting
Problem
The Cognos Audit package provides information on a reports execution time in milliseconds and a timestamp that corresponds to the completion time for the report. The start time of the report is not provided in the Audit package.
How can the start time for a report be reported on with the Audit package similar to the how the start time of the report can be seen in the reports run history?
Resolving The Problem
You can calculate the start time for a report based on the [Audit].[Run Reports].[Time stamp] date time and [Audit].[Run Reports].[Execution time] in milliseconds.
Start time can be calculated as follows:
_add_seconds([Audit].[Run Reports].[Time stamp],(([Audit].[Run Reports].[Execution time]/1000)*-1))
Related Information
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d78AAA","label":"Reporting"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.7;and future releases","Type":"MASTER"}]
Historical Number
1035902
Was this topic helpful?
Document Information
Modified date:
14 December 2022
UID
swg21342328