Hello,
I would like use the Cognos Audit database to follow the report execution in the platform Cognos (as frequently used).
Unfortunately I found a lot of strange report name in the run reports table.
In a simple report, I added a list based on data from reports ... but the report name, I mostly had this kind of information: RES_1 ...
For example: RES_1: 11b75c32ec794fc280cb9a25e08236b9
This execution has the type 'ReportService Report' in the report type column and the search path that points into a workspace ... without any information on the execution report.
How can I manage this kind of information? How can I retrieve the executed report?
Thanks in advance.
Yohann
Quote from: Y.CROZET on 28 Jul 2015 07:32:45 AM
Hello,
I would like use the Cognos Audit database to follow the report execution in the platform Cognos (as frequently used).
Unfortunately I found a lot of strange report name in the run reports table.
In a simple report, I added a list based on data from reports ... but the report name, I mostly had this kind of information: RES_1 ...
For example: RES_1: 11b75c32ec794fc280cb9a25e08236b9
This execution has the type 'ReportService Report' in the report type column and the search path that points into a workspace ... without any information on the execution report.
How can I manage this kind of information? How can I retrieve the executed report?
Thanks in advance.
Yohann
Hi,
When a user drags a report or a component of a report into a Workspace, under the covers a new "report" gets created in the content store containing the XML required to render the widget in the workspace. This has a generated name beginning "RES_1". What you are seeing in the audit database are the instances where these "reports" have been executed as a result of someone viewing the workspace they are included in as widgets.
Cheers!
MF.
Quote from: Y.CROZET on 28 Jul 2015 07:32:45 AM
Hello,
I would like use the Cognos Audit database to follow the report execution in the platform Cognos (as frequently used).
Unfortunately I found a lot of strange report name in the run reports table.
In a simple report, I added a list based on data from reports ... but the report name, I mostly had this kind of information: RES_1 ...
For example: RES_1: 11b75c32ec794fc280cb9a25e08236b9
This execution has the type 'ReportService Report' in the report type column and the search path that points into a workspace ... without any information on the execution report.
How can I manage this kind of information? How can I retrieve the executed report?
Thanks in advance.
Yohann
The report name that the widget is based on can be found at the end of the RES_1 stuff following the hash # sign. The code below parses the report name for widgets as well as other scenarios making it more readable than what you get by default from the audit database.
replace ( case
when [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] is null
then 'Unsaved Report'
when [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] = ''
then 'Unsaved Report'
when [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] = 'adHocReport'
then 'Unsaved Report'
when position ( 'report[@name=''RES_' , [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] ) = 1
then substring ( [COGIPF_RUNREPORT].[COGIPF_REPORTNAME],
position ('#' , [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] )+1 )
when position( 'report[', [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] ) = 1
then substring ( [COGIPF_RUNREPORT].[COGIPF_REPORTNAME], 15 )
when position( 'reportView[', [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] ) = 1
then substring ( [COGIPF_RUNREPORT].[COGIPF_REPORTNAME], 19 )
when position( 'interactiveReport[', [COGIPF_RUNREPORT].[COGIPF_REPORTNAME] ) = 1
then substring ( [COGIPF_RUNREPORT].[COGIPF_REPORTNAME], 26 )
else [COGIPF_RUNREPORT].[COGIPF_REPORTNAME]
end
, ''']','' )
#/* Widgets are recorded with a prefix such as RES_1:b513cd0d627501d014a077db68cd9534# followed by the title on the widget. To make this more readable we first check if the prefix is present by looking for RES_ in the string. If it is found, we substring from one position after the hash sign to the end of the string.
For example:
RES_1:ebfc37ab3433061e941ccbc6bf3046f3#Sub Contract Cost WTD
becomes
Sub Contract Cost WTD
*/#
Hello,
Thank you for your answers.
Unfortunately I do not have the report name after the hash # sign.
The report name is only RES_1: 7145b06f105d0dc0892111c7f29044a6
So I opened a case with IBM support and this is their response:
APAR PI37800
Title: IN examples of workspace reports, the report name in TABLE AUDIT COGIPF_RUNREPORT is not returned.
Description: Instead of the report name, he's back REPORT_ID in the output.
Resolved Cognos 10.2.2
Now we are in reflection to migrate version (this problem is not the only reason to migrate).
Yohann