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?
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.
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 "parameterValues" and "options".
---------------------------------------------------------------------------------
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.
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 "parameterValues" and "options".
Related Information
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Type":"MASTER"}]
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21706083