How to Pass Parameters to avoid the prompts in the report.

[cesquilin]

Hi,

I am trying to run a Cognos Report(8.3) from an external portal, but I need to pass some parameters to avoid the prompts in the report.  Those parameters are dynamically.  I any one of you has done this before please, give me some inputs.  Thanks in advance for your help and time.


Best Regards,

cesquilin  :-\

[sir_jeroen]

Have you added the option: run.prompt=false to your url?

Source: Cognos Proven Practices -> Reporting -> Scripting techniques

http://support.cognos.com/supported/tti/public/docs/cognos_pp_reporting_using_urls_in_cognos_8.pdf?lid=cognos_pp_reporting_using_urls_in_cognos_8


Good luck,

RA

[cesquilin]

Hi again,


Thanks for your reply; But, how I deal with the security? Meaning the call to the report is from an external application that will integrate with Cognos to serve the reports; for this reason it is important to authenticate the user before execute the reports. The user needs to be allowed to use Cognos. Also this must provide a single sign-on. To complete the requirements this userid parameter need to be assign to the #$account.defaultName# parameter to apply row level security in the FM package. Thanks in advance for any input provide…

Regards,
cesquilin

[sir_jeroen]

You could use CAMPassword and CAMUsername as URL parameters (Look in the source page of the login page).