IBM Support

Logging Selected Report Parameters in the Audit DB

Technote (FAQ)


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

Document information

More support for: Cognos Business Intelligence
Cognos Administration

Software version: 10.2, 10.2.1, 10.2.2

Operating system(s): AIX, Linux, Windows

Reference #: 1706083

Modified date: 23 December 2016


Translate this page: