Skip to Content

Creating Tableau Report on BW Infocube a Two Step Process

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.

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