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
- Open the Tableau and create new report.
- Click Connect to Data (Ctrl+D)
- Select “SAP NW Data Warehouse”
- Add new connection
- Establish the connection
by pressing the “Connect ” button
- Browse the Info Cube objects, Select the Info Cube
- Select the Queries available over the same Info
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.