Skip to Content

Details:

A three-step procedure for creating a Tableau Report over SAP HANA – Analytic View.  The basis for creating this Analytic view is
on the Sales and Purchase data generated in Legacy Systems and then loaded to SAP HANA IMDB.

Step1:

Create an Analytic View on SAP HANA DB:

Definition: Analytic View = 1Fact Table (with Key figures) + ( 1 or more Tables/Attribute views )

 

Step2:

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

1.JPG

2.JPG

Step3:

 

  1. Select “SAP HANA”
  2. Add new connection
  3. Establish the connection by pressing the “Connect ” button
  4. Browse the Schema (Use the filter = _SYS_BIC ),
    Select the Analytic  (Previously created )
  5. Create the required report by dragging the required measures and
    dimensions.

3.JPG

4.JPG

5.JPG

6.JPG

7.JPG

Conclusion: I was able to design and develop a medium complex Tableau report over SAP HANA – Analytic View n 4 Hrs.

To report this post you need to login first.

5 Comments

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

Leave a Reply