Skip to Content
Author's profile photo chandra koduri
chandra koduri
January 6, 2017 Less than a 1 minute read

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

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      HI ,

      Nice Document  but may i know why you added

      &lsSEnter value(s) for State=”+state_text;

      directly you can pass ”+state_text; right?

      Thanks,
      Varun

      Author's profile photo chandra koduri
      chandra koduri
      Blog Post Author

      Hi Varun

      Here &lsSEnter value(s) for State=”+state_text;

      &lsS: Specifies a value for a single prompt.

      Enter value(s) for State= : Webi report prompt text.

      +state_text :this is variable we can state variable.

      Thanks,
      Sekhar

      Author's profile photo Martin Pankraz
      Martin Pankraz

      Hi Sekhar,

      You should definitely add the link to the OpenDocument documentation for others to find the syntax required for their needs.

      https://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_opendocument_en.pdf

      In addition to that others will be looking for ways to save coding in DesignStudio and standardize their approach. How about adding some ideas about that? You would probably start off coding some global scripts.

      Kind regards
      Martin