Skip to Content

Open Doc Syntax in Design Studio


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;


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.


You must be Logged on to comment or reply to a post.