COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jatin.popat on 23 Jul 2010 03:14:39 AM

Title: How to pass userid and password for user in the URL of cognos report (urgent)
Post by: jatin.popat on 23 Jul 2010 03:14:39 AM
Hi,

I have 1 report which i need to run 5times using different values of a particular prompt and then send it to a user thorugh email.

My user don't want the report to be scheduled in cognos connection for the same.

So I am using the following URL to run the report :

http://snycd86m:80/cognos8/cgi-bin/cognosisapi.dll?b_action=cognosViewer&ui.action=view&ui.object=defaultOutput
(%2fcontent%2ffolder%5b%40name%3d%27Daily%20Snap%20Shot%27%5d%2ffolder%5b%40name%3d%27Daily%20Reports%27%5d%2freport%5b%40name%3d%27New%20NA%20DSR%20from%20Development%27%5d)&ui.name=New%20NA%20DSR%20from%20Development&ui.format=PDF

But when ever i try to run the report using URL, I am prompted for userid and pwd necessary to login to the cognos connection..

So please lt me know if I can pass these values to the URL ...................
Title: Re: How to pass userid and password for user in the URL of cognos report (urgent)
Post by: MFGF on 23 Jul 2010 05:02:07 AM
Try adding

&CAMUsername=YourUserID&CAMPassword=YourPassword

to the URL.
Title: Re: How to pass userid and password for user in the URL of cognos report (urgent)
Post by: jatin.popat on 23 Jul 2010 05:13:03 AM
Thanks a lot .......................

It worked...


Cheers !!