Hi
Using Open Doc syntax to connect from SAP Design Studio application to Web Intelligence Report.
Datasource: Universe(ODBC Connection)
Design Studio version : 1.6 SP03
Step1: Create Web Intelligence report using universe and assign optional prompts.
Example Step1: Create Web Intelligencereport with State,city and sales revenue fields.
Here state is optional prompt and save the report.
Step2: Create Design Studio Application using same universe.
Add crosstab ,
User Interactivity : Selection Type(Single)
and On select write below script,
var state_text= CROSSTAB_1.getSelectedMember("OBJ_218").text;
var newurl="http://<Servername>:<Port number>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AUFR1QOfTkRNjG85YG4U0SE"+
"&lsSEnter value(s) for State="+state_text;
APPLICATION.openNewWindow(newurl);
Here,
OBJ_218 = State variable
Webi Document link:
http://<Servername>:<Port number>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AUFR1QOfTkRNjG85YG4U0SE
and execute Design studio application, click on state then shows state related details webi report.
Any modifications required in the blog please guide me.
Thanks,
Sekhar