COGNOS Audit and Getting the Parameters Passed

[gosoccer]

friends,
If anyone knows which table in Cognos Audit environment can be used to identify the "Parameters" that was passed
to the report through the prompt page, could  you please let me know.

I have to run 50-100 reports to gather performance statistics and being able to produce the report to show the report that was
ran and the parameters that was utilized will be saving me a lot of time.

I'm using a report that is called View by Package and Report and it gives me the time and user name and the report but now,
I just need to get the parameters.
;D
Thank you in advance for your time.

[cognos810]

Inititally thought COGIPF_PARAMETER should do the trick, but does not appear to be working for me.

[gosoccer]

Yeah! I'm thinking it would be a column/table that shows the SQL used. Haven't figured it out yet!
Thx for the reply! I'll keep looking!!!

[cognos810]

Hello gosoccer,
I know that the query can be written to cogserver.log file by enabling the "Audit the native query for report service" . It should also write it to the audit tables(I am going to try it, right away). But will that help you? You will have to parse the SQL generated to find out the parameter values.

[gosoccer]

Since you have been mind enough, I would like to share this with you and the COGNOISE site.

Here are the steps:

Phase I
1) Create Report Views and Name the Reports based on the scenarios. Like Finance, One Day, 10 Sites.
2) Establish a Job and have all the reports with the different names and scenarios in the job.
3) Run the Jobs (Sequence or Together depending on your goal)

Phase II
1) Navigate to Cognos Report Portal
2) Select the My Area Options, Activities and Schedule.
3) Copy and Paste all the entries showing start date/time and completion date/time into a spreadsheet.

At this point, the report views with different names will be shown as a part of the spreadsheet along with their
start and completion time.

Hope this help!

I'm sure there is a way to do this using Audit but my time is so limited, it is unbelievable!!

Thx so much!

[atmus_br]

Hey guys! I'm not sure if you're still looking for it, but this link seems useful:
https://www-01.ibm.com/support/docview.wss?uid=swg21706083

Logging Selected Report Parameters in the Audit DB
Question: How to store the user selected Report Prompt Parameters and Report Run Options into our Audit DB. Where is this information stored in the DB?

Answer: How to Enable
---------------------------------------------------------------------------------
In Cognos Administration, in the Batch Report Service and Report Service "Advanced Parameters" options, enable the "RSVP.PARAMETERS.LOG" parameter and set its value to true. Also be sure that the logging levels on the report and batch service are set to Basic.

For information on this an other advanced settings values: http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.dg_sdk.10.2.2.doc/r_reportService_adv_settings.html%23reportService_adv_settings

Where to find it
---------------------------------------------------------------------------------
In the Audit Database, the prompt value should be within the
User's schema name > Parameters table (COGIPF_PARAMETER) > COGIPF_PARAMETER_VALUE_BLOB column.

The output for the COGIPF_PARAMETER_VALUE_BLOB is given in XML format for both the COGIPF_PARAMETER_NAME's "promptValues" and "options".