COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: udung on 13 Mar 2014 03:09:41 AM

Title: how run report by passing parameters via url
Post by: udung on 13 Mar 2014 03:09:41 AM
Hi All,

i want to run report by passing parameters via url?
please advise


thank u
Title: Re: how run report by passing parameters via url
Post by: BigChris on 13 Mar 2014 03:13:03 AM
Give us a clue...
Title: Re: how run report by passing parameters via url
Post by: udung on 13 Mar 2014 03:27:59 AM
Quote from: BigChris on 13 Mar 2014 03:13:03 AM
Give us a clue...

Hi Cris,

actually i was create a report using OpenStreetMap, please see below link:
http://www.ibm.com/developerworks/library/ba-pp-reporting-advanced_report_design-page671/index.html?ca=drs#close-N10126

i have problem when i want to see report in map, i mean this is a drill through to another report via url

below my url (wrong):
https://192.168.218.180:9082/reporting/servlet/dispatch?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27Learn%27%5d%2freport%5b%40name%3d%27revenue%20map%27%5d&ui.name=revenue%20map&run.outputFormat=&countryName='+ countryName +'


please advise how to run report by passing parameters via url


Thank u
Title: Re: how run report by passing parameters via url
Post by: nblank on 13 Mar 2014 04:56:13 AM
Found this pdf: http://www.segmentbi.com/images/stories/food/passing%20parameter%20through%20url.pdf (http://www.segmentbi.com/images/stories/food/passing%20parameter%20through%20url.pdf)

Perhaps it can help you.

Nanno

Title: Re: how run report by passing parameters via url
Post by: udung on 13 Mar 2014 05:19:10 AM
Quote from: nblank on 13 Mar 2014 04:56:13 AM
Found this pdf: http://www.segmentbi.com/images/stories/food/passing%20parameter%20through%20url.pdf (http://www.segmentbi.com/images/stories/food/passing%20parameter%20through%20url.pdf)

Perhaps it can help you.

Nanno

Hi nblank,

i was tried it, but still fail to filter report base on parameter

url:
https://192.168.218.180:9082/reporting/servlet/dispatch?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27Learn%27%5d%2freport%5b%40name%3d%27revenue%20map%27%5d&ui.name=revenue%20map&run.outputFormat=&run.prompt=true&P_Country=Australia


fyi:
if run.prompt=false, the report not filtered by country name


please advise

Thank u
Title: Re: how run report by passing parameters via url
Post by: udung on 13 Mar 2014 06:23:31 AM
Solved

thank u everyone
Title: Re: how run report by passing parameters via url
Post by: MFGF on 13 Mar 2014 07:15:26 AM
Quote from: udung on 13 Mar 2014 06:23:31 AM
Solved

thank u everyone

Do you mind sharing the solution? It may help other people looking for a similar technique in future...

Cheers!

MF.
Title: Re: how run report by passing parameters via url
Post by: udung on 14 Mar 2014 03:06:31 AM
Quote from: MFGF on 13 Mar 2014 07:15:26 AM
Do you mind sharing the solution? It may help other people looking for a similar technique in future...

Cheers!

MF.

Hi MF,

i missing to append "p_" to the beginning of the parameter name


thank u