Cognos Audit - Run report name

[Y.CROZET]

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

[MFGF]

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.

[Lynn]

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.

Code Select Expand


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
*/#


[Y.CROZET]

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