Bypassing Prompt window in URL Reporting

[Former Member]

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 !

[Former Member]

Post Author: Ted Ueda

CA Forum: JAVA

A reference for OpenDocument to invoke Webi docs is found in the "Building Reports Using the Web Intelligence Java Report Panel" found on the support site, in the section that describes how to link documents.

Prompts are specified using lsS&#91;name&#93;=&#91;value&#93; or lsM&#91;name&#93;=&#91;value&#93;, depending on whether the prompt is single or multi-valued. The &#91;name&#93; should be the prompt, for example lsMEntercitynames:=&#91;Vancouver&#93;,&#91;Paris&#93;

Sincerely,

Ted Ueda