If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Looging report prompt values

Started by Mari, 04 Mar 2015 05:57:51 AM

Previous topic - Next topic

Mari

Hi!

I have reports based on FM model, in this model I use oracle stored procedures with input parameters.
Is it possible after every running of report to make record in log with values of report parameters? What way it could be done?

I've made some logging settings for а dispatcher and I see in repository some information, but it's not enough.
Now I see in COGIPF_NATIVEQUERY.COGIPF_REQUESTSTRING   records like this { CALL MY_DB.MY_PKG."MY_PROC"(?,?,?,?)}? but I need more detail, records like this (not only symbols "?"): { CALL MY_DB.MY_PKG."MY_PROC"('2015/03/01','2015/03/04',35,'10,50,100,5000,')}

Thanks!

tlambert

You could insert script in your report to scrape the page for prompt names and values (complex but doable), then do 1 of 2 things.

1) POST parameters to a separate web service which will receive the parameters and write them to your database. We have a working use case which does this. This is a complex solution.
2) write script in the report to then insert the parameters as a text string into a new text prompt (this is possible) and submit that prompt to another stored procedure (this might not be possible or cause recursion). You might need to require the user to manually submit the prompt.

Alternative 3rd possibility - the parameters MAY be stored with the report instance and MAY be accessible via SDK. We looked into this but abandoned for our project.

Andrew Weiss

When the report is executed the report's Run History records the parameters that were supplied.  You can easily extract this information into an Excel report using MetaManager's Content Documenter module.  In the attached example I ran a prompted report and then documented this report's run history information to Microsoft Excel using the Content Store Documenter Module.

You can see more about the module here:
http://www.bspsoftware.com/Products/MetaManager/Document

Let me know if you're interested in a demonstration of this solution.

Thanks,
-andy
MetaManager makes administering IBM Cognos a breeze.  http://www.bspsoftware.com/MetaManager