IBM Support

Logging Selected Report Parameters in the Audit DB

Question & Answer


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".

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Administration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21706083

Page Feedback