Creating Tableau Report on BW Info Cube a Two Step process.

Problem / Opportunity Statement:

My client is a Telecommunication Giant with a position in fortune 100 list. Currently having 500+ reports in the tools like BEX, BO Web-I, Dashboard, BPC. To enable easy & quick data understanding to a user group (Few) i.e. Business Reports. I have decided to design few reports (50 No’s) in Tableau 8.3. So I have starting looking in adoptability to Tableau tools to BW.

Solution: A simple 2 step process to create Tableau Report on BW Info Cube. BW meta data and cube data access is very good and easy to configure

Step-1:

  1. Open the Tableau and create new report.
  2. Click Connect to Data (Ctrl+D)

Slide1.JPG

Slide2.JPG

Step-2:

  1. Select “SAP NW Data Warehouse”
  2. Add new connection
  3. Establish the connection
    by pressing the “Connect ” button
  4. Browse the Info Cube objects, Select the Info Cube
    (Required)
  5. Select the Queries available over the same Info
    Cube.
            

Slide3.JPG

Slide4.JPG

Slide5.JPG

Slide6.JPG

Slide7.JPG

Slide8.JPG

Conclusion:
I was able to design a good and medium complex Tableau report On BW within 2
Hrs. Likewise I could deliver 10 Medium and 5 High Complex reports in 40 Hrs.

To report this post you need to login first.

15 Comments

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

  1. Nanda Anantha

    Hi Ashok,

    Nice document.

    I have one question after creating report how users accessing Tableau report , I mean, generally BEx report can access at analyzer how about Tableau report where can log in access Tableau reports.

    Regards,

    Nanda

    (0) 
  2. Jason Kraft

    I have been working with Tableau connecting to BW 7.3 for about a year now. We started out with Tableau’s built-in BW connector, it was fine for simple queries with small data sets but it was too slow for anything more complex.

    We ended up using Theobald Software’s Xtract Universal toolset instead, it can handle much larger data sets and utilization on the BW system when creating TDEs is lower. It doesn’t have built-in functionality for publishing TDEs to Tableau Server but you can schedule tabcmd jobs to do that.

    http://theobald-software.com/en/xtract-universal-productinfo.html

    (0) 
  3. Sarthak Bhatta

    Hello Ashok,

    Thanks for your post .

    Please suggest its performance when we are dealing with large amount of data .
    Is it working fine ?
    And Secondly can we create variables and do a hierarchical reporting as we are doing in Bex.

    Regards,
    Sarthak

    (0) 
    1. Ashok Babu Kumili Post author

      Hi Sarthak,

      The performance is good as I have tested for a 2 Million+ records. It is very decent performance.

      Creating the variable is easy and doing hierarchical reporting is possible.

      Best wishes.

      (0) 
  4. Suee Elven

    Hi Ashok,

    We used to have Tableau server 8.0. And also we used connect to SAP BW using tableau.

    But after upgrading to 9.2 64 bit, SAP BW workbook is throwing an error saying “class not registered”.

    We have SAP GUI installed on our desktop. Anything else is required to install?

    Or is there any dependency on tableau server version on SAP BW driver?

    Is there any tableau 9.2 specific SAP BW driver?.

    Can you help me out of this? 😕

    Thanks,

    Suee

    (0) 

Leave a Reply