Bypassing Prompt window in URL Reporting

31 Views

Post Author: gkottapalli

CA Forum: JAVA

Hi All,

I am trying to pass some parameters from a JSP page to Webi report using OpenDocument method.

I created a sample webi report with one filter as a prompt. I want to send that parameter value from the jsp screen and I want the screen to open up the report with data related to the filter passed. Instead of opening the report, Prompt window is opened and after selecting the value and running the query the report is generated.

In some of the posts I read that if correct query string is built with lsS<paramName>=<paramValue> option, the prompt window will be bypassed.

In my case, I am not sure if I built the hyperlink correctly and I need your help in this case.

The URL I created is as follows and I tried all possible ways of the filter company and none of them worked (see commented below):

String URLrequest = "http://" + logonform.cmsname + ":8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?iDocID=" + docID + "&sType=wid" + "&lsSCOMPANY_ID_CID=AAI" +

// "&lsSCompany
Company=AAI" +

// "&lsSCompany=AAI" +

// "&lsSGFSTA34_SOURCE_APPL_ACRONYM.COMPANY_ID_CID=AAI" +

"&token=" + enterpriseToken;

The Query behind the BO report is :

SELECT GFSTA34_SOURCE_APPL_ACRONYM.COMPANY_ID_CIDFROM GFSTA34_SOURCE_APPL_ACRONYMWHERE GFSTA34_SOURCE_APPL_ACRONYM.COMPANY_ID_CID In @prompt('Enter value(s) for Company:','A','Company\Company',Multi,Free,Persistent,,User:0)

Any help is greatly appreciated.

Thanks !