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

Passing parameter from different application

Started by madhansun, 08 Jan 2009 07:08:02 AM

Previous topic - Next topic

madhansun

Hi Gurus
   I need of some help how we can pass parameter from different application and run the report in cognos8.2.

  I have web based application and i have to enter the report without using the prompt in the cognos but need to filter by the help of third party application can you please advice on this.

Regards
K.mathan

Sunchaser

Hi,

If you have access to Cognos support, there's a documentation about this which gives you example of using parameters in URL in order to launch reports from "outside".
If so, I could give you the reference to.

I think that you should use POST method (and so, a form) if it's possible, because else you'll have problems with the size of URL generated for launching reports.
For example, in my "environment", the static part of the URL for a report is:
"
http://localhost/c83/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/launch.xts&ui.tool=CognosViewer&ui.action=run&ui.object=/content/package[@name='Package_Name']/folder[@name='Folder_Name']/report[@name='Report_Name']
"
Depending on the need, I do a concatenation with:
"
&run.prompt=false&run.outputFormat=PDF
"
In my web page, I've a form (in a IFrame) containing hidden inputs.
Each hidden input have a "Name" property set with the name of the parameter in the Cognos prompt page.
For example, if I have a parameter in the Cognos prompt page named "Param_Year", then I have a hidden input in my form with a "Name" property set to "p_Param_Year".

I give to the hidden inputs concatenation like:
<selectChoices><selectOption useValue= + AValue + /></selectChoices>
where 'AValue' is the value to be passed to the parameter.
Of course, it's working for multiselect prompt, you just have to repeat the same concatenation.

You'll have to give a value to every parameter in your Cognos prompt page.

As I'm not the "King of Cognos", someone else might have some better technics, some advices of course.

Hope it could help you,
vinc.