Skip to Content
Author's profile photo Ashok Babu Kumili

Creating Tableau Report on SAP HANA Analytic View a Three Step Process

Background 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.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thank you

      Author's profile photo Former Member
      Former Member

      Great technical info. Thank you

      Author's profile photo Harshit Pandey
      Harshit Pandey

      thank you

      Author's profile photo Former Member
      Former Member

      Thanks.. Nice document.

      Author's profile photo Former Member
      Former Member

      Tanks...Nice Document.