Save user prompt selections in database

[Cognosuser2019]

Hi All,

Is there way to capture the user prompt selections and save it in database. Users want to know what report was run by the user along with the prompt selections for audit purpose. If it is possible can you please provide the details or direct me to any document links.

[Michael75]

Hi,

It's not present in standard Cognos functionality, but take a look at this:

http://ibmcognosrmug.files.wordpress.com/2011/05/cps-promptset-manager.pptx

It references a custom application created by BSP (now Avnet), who host the Cognoise site. Whilst the aim here is different from yours, the idea of interacting with a DB to manage prompt values is part of what you're looking for. At least, it could give you some ideas...

[maxchuie]

Has anyone been successful in saving prompt values to a sql server database?

[dougp]

This is one of the changes to my environment I'll be proposing to my managers once I have had the resources to develop and test the solution.  This is what I have documented so far:


IBM has published a technote that covers this: https://www-01.ibm.com/support/docview.wss?uid=swg21706083

Cognos can audit report parameters to the IBMCognosAudit database. The data is stored as XML in ntext in IBMCognosAudit.dbo.COGIPF_PARAMETER.COGIPF_PARAMETER_VALUE_BLOB.

1. Open Cognos Administration.
2. Click on System.
3. Change the view from All Servers to Report.
4. On the Report Service, select Set properties.
5. Go to the Settings tab.
6. In Environment/Advanced settings, click on Edit...
7. Add a record for Parameter = RSVP.PARAMETERS.LOG and Value = true

The technote says to do the same to the Batch Report Service.

Reporting from this data can be challenging. Ideally, the XML should be parsed and stored in a table. I'll use this as an opportunity to improve my skills with XQuery and XPath.