To Send Dynamic filter values to Cognos reports

qlik_venu — Sat, 12 Mar 2011 04:54:55 GMT

Hi,

I need to pass parameter values from Qlikview to Cognos.

For examples, I have a straight table object and a Text object.

I should be able to provide a hyperlink in the text object which is just besides the Straight table object.

The Straight Table object has columns Country, State and sales.

Is i have selected USA ( Country), New York (State) in the straight table and then select on the Text object hyperlink, it should be able to RUN a Cognos Report.

Here is the UDL from Cognos which would accept the prompt values to RUN a 'Country_Report'

http://cognos/c8/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/launch.xts&ui.tool=CognosViewer&method=execute&ui.object=/content/folder[@name='Reportfolder']/folder[@name='subfolder']/report[@name='Country_Report']&ui.action=run&b_action=cognosViewer&run.outputFormat=HTML&run.prompt=false&p_p_Country=USA&p_p_state='NewYork'

Normally we change the paramter values at the end of the above link to variables and then send values from .Net Application for a different project.

But in the present one its just going to be qlikview and Cognos. So your suggestions are needed. Thanks.

Venu

topic To Send Dynamic filter values to Cognos reports in QlikView

To Send Dynamic filter values to Cognos reports