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

To report this post you need to login first.

3 Comments

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

  1. varun garaga

    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

    (0) 
    1. Chandra Sekhar K 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

      (0) 
  2. 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

    (0) 

Leave a Reply