Skip to Content

In order to have more charts options in Web Intelligence, you have the possibility to embed an Xcelsius chart into a Web Intelligence report. Here are the steps to achieve this. (Please note that this will only work in a DHTML Web Intelligence report)

1st step : Build your Xcelsius dashboard to include the visualization of your choice (gauge chart in this example)

1) Create the Xcelsius dashboard as in the picture above. The green cell contains the formula for the

country dimension lookup:+

=VLOOKUP(B2,B5:C6,2)

+The yellow cells are the business objects data from a webservice on beach

universe (Country and Sales Revenue)

The grey cell is the variable “Country”

2) Then, create a Flash variable named “country” and

assign it to the grey cell

3) Assign Data by indicators and assign the

value from the green cell. 

4) Save

and export the Xcelsius dashboard to SAP BusinessObjects Entreprise.

2nd Step: Building the Web Intelligence document

5) In Infoview, retrieve the docID of the

Xcelsius object you exported.

6) Create a Web Intelligence document based on Beach

universe, with a table (Country, Revenue), and add a Free Cell that you will

set to “Read as HTML”.

The free cell should have a formula like :

=”<iframe

width=”Char(34)“640”Char(34)

height=”Char(34)“480”Char(34)

frameborder=”Char(34)“0”Char(34)

scrolling=”Char(34)“no”Char(34)” marginheight=”Char(34)“0”Char(34)

marginwidth=”Char(34)“0”Char(34)

src=”Char(34)http://<server>:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=9708&lsScountry=”

(Country) Char(34)“+>”

7) Set the table as an input control (http://help.sap.com/businessobject/product_guides/boexir31SP2/en/xi31_sp2_webi_oran_en.pdf)

8) Click on a value (e.g., France) from the table, your report should like this:

!https://weblogs.sdn.sap.com/weblogs/images/252066785/final.GIF|height=346|alt=|width=574|src=https://weblogs.sdn.sap.com/weblogs/images/252066785/final.GIF!</body>

To report this post you need to login first.

11 Comments

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

  1. Matthew Shaw
    thanks for the blog, could be handy this.

    I was thinking could we use a relative address over a fixed address?

    i.e. use: /OpenDocument/..
    instead of: http://:8080/OpenDocument/..
    Or won’t that work?
    Relative addresses would mean less problems with reverse proxies, load balancers, promotion of content between dev, test and prod, also no need to update the server:port if it changes!

    thanks, Matt

    (0) 
    1. Romaric SOKHAN Post author
      Hi Matt, according to the iframe specification this should work

      Value     Description
      URL     The address to the document to show in the iframe.

      Possible values:
      An absolute URL – points to another web site (like src=”http://www.example.com/default.htm“)
      A relative URL – points to a file within a web site (like src=”default.htm”)

      I haven’t tested though as i re-snapshoted my VM!

      (0) 
  2. Ryan Goodman
    This is a great post.. I wish SAP would please add this kind of functionality to WebI out of the box.. Not rocket science here.

    Thanks again!

    (0) 
    1. M Mohammed
      You are obviously insert the whole formula in a text cell, click that cell and go to the properties tab, in Display there is an option Read cell content as, select HTML in its drop down list.
      Hope that helps.
      (0) 
  3. M Mohammed
    Hi,
    Using this feature, can I call the SWF files from the InfoView in a Webi Report.  Suppose I have a Dashboard being used by the users in the InfoView and that Dashboard has live data.  Can I embed that dashboard in a Webi report?  If yes, will it work fine in a report too?  This is something which would be really cool if possible.
    (0) 
  4. Phet Photirath
    Just wondering if I’ve done anything wrong. I’ve done the same thing and it’s worked and displays the report and refreshes nicely but I noticed that once you try to close the report in InfoView, the swf files keep loading up as well as the report itself again. Have I missed something or should I raise this as an issue?
    (0) 

Leave a Reply