Skip to Content

Applies To:

SAP Business Objects XI R3.x

SAP Business Objects BI 4.0

Tableau Server

Summary:

There have been a lot of inqueries on how we can utilize Business Objects and Tableau together. Currenlty we cannot leverage universes to be used with Tableau but we can use existing Webi , Crystal Reports and Xcelsius Dashboards with tableau. This article discusses the use of Tableau Dashboard integrated into a webi report where we can simultaneously drill down in to both the Webi report and Tableau Dashboard. The solution will work only if the Tableau Dashboard is available on a server.

Data Source Used for Business Objects : e-fashion universe

Data Source Userf for Tableau : e-fashion access database

I have a Tableau Dashboard that is built against efashion showing a heatmap of Sales Revenue for each efashion store published to Tableau server.

Tab3

 
The next thing i did was create a webi report against efashion universe to show the city and sales revenue for a year. The idea here is to drill on a city in the webi report to see a distribution of sales revenue by stores within that city. in order to integrate Tableau within business objects i am using two features hyperlinking and iframes. Below is a snapshot of how the report would look before we drill down on a city. I have loaded the Tableau dashboard to show in the iframe when the webi report is first opened. We can tweak the code so that Tableau dashboard only loads when we drill on a city.

Tab1   

Once we drill on a city the view would be as below

tab2

In order to accomplish the above i have created two variables one i named as Hyperlink which is used to show the city Values and pass them to the Tableau Dashboard in the table and the other is called iframe which is used to load the Tableau Dashboard in the iFrame.

Hyperlink – =”<a href=http://tablud01/t/Development/views/EfashionStoreRevenue/EfashionStorerevenue?:embed=y&:display_count=no&:refresh=yes&:linktarget=_self&Yr=“+[Year]+”&City=”+[City]+”\” target=\”TableauView\”>”+[City]+”</a>”

iFrame – =”<iframe id=\”TableauView\” name=\”TableauView\” height=’413px’ width=’550px’ frameborder=’0′ src=’http://tablud01/t/Development/views/EfashionStoreRevenue/EfashionStorerevenue?:embed=y&:display_count=no&:refresh=yes&:Yr=[Year]&:City=[City]‘></iframe>”

To report this post you need to login first.

3 Comments

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

  1. Graham Macleod

    Hi Tauseef. This is brilliant! 😀 I have been trying to figure this out for ages.

    Initially, until a city is clicked on my test, I get “Internet Explorer cannot display the webpage”. How did you get it to open the viz by default? I’m assuming the problem I am having is because the City and Year parameters are not set until I click on the hyperlink.

    Edit: In order to make this work when the report is first opened I had to remove the parameters “&:Yr=[Year]&:City=[City]” from the iFrame URL.

    One point worth making is that this only works when in HTML mode and not in java mode.

    (0) 
  2. Vijay B

    Hi Tauseef,

    The above mentioned approach has been tried in Tableau 9.1 & BO 4.1, however, a error is getting displayed while parsing and using it as the hyperlink.

    (Actually link works and opens server , if all the syntax till :embed is used but is throwing error lateron )

    Can you please let me know other method, if any, for the creation of Hyperlink.

    (0) 
  3. Deepu Reddy

    Hi Tauseef,

    Thanks for this blog.

    However due to X-Frame Headers from Tableau Server, Tableau Dashboard is not loading into WEBI report. Could you please let me know how this has been taken care.

    We cannot ask every user to add Extension to Ignore X-Frame headers on their browsers.

    -Thanks,
    Deepu

    (0) 

Leave a Reply