Skip to Content

Open Doc Syntax in Design Studio

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

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