Creating Tableau Report on BW Infocube a Two Step Process

[former_member181999]

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)

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.

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.