Invoke JSP page from Report Studio and pass parameters

[rm1234]

Hello

My requirement is as follows. I have a mix of reporting and transaction (update) requirements. Admin users can do db updates via JSP screen and while normal users can run cognos reports or do view only on the JSP.

I am intending to use the Cognos environment to manage users, groups, folder structure etc.

My proposed solution is:

I am using Cognos 8 and have 2 separate folders. One Folder Called 'ADMIN' which has a number of links (urls) to invoke JSP pages. This is to allow only admin users to perform db updates.

Another Folder called 'USER' which has a number of links to Report Studio Reports, and also the JSP urls which will be view only.

Following are my queries.

1)Is it possible to pass user group / folder name information via url (Cognos Connection) to the jsp page. This will then give me greater flexibility to determine from where the screen has been invoked and hence decide to allow db update or not?

2) Is it possible to invoke a JSP page from Report Studio and pass parameters.

3) Does anyone have a better solution to handle the above requirement.


Thanks...

 

[BICentre]

Hello, yes you can pass user credentials and report path information via URLs. I would use my .jsp app to launch cognos reports and not cognos to launch .jsp pages. You could also add a hyperlink object to Cognos Connection and set the url to your java application, or you could add a HTML item to your Report Studio report and set url values to launch. Lots of options.

http://bicentre.blogspot.com

Wallace Taylor

http://bicentre.blogspot.com

 

[rm1234]

The reason why I want to use Cognos for launching JSP pages is that

1) Cognos gives me ready made functionality to manage users, groups, login, folder structure etc. If I have to recreate the same in JSP effort would be much more.

2) The application is mainly reporting with a few data update screens done in JSP


Pls let me know your views..

 

[BICentre]

Hello, it could get a little tricky going from cognos to jsp but depending how indepth you're going to get it's possible. I would do a proof-of-concept by adding a URL Item to Cognos Connection and specify the url value as one of your .jsp based urls. You could manually append the url string (ie.

http://server1/mytest.jsp?update=1),

but you may run into some issues of trying to get session or application variables passed through your urls.

You can get the url path for Cognos Connection items by going into the item's property and copying the url path.

http://bicentre.blogspot.com

Wallace Taylor

http://bicentre.blogspot.com