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.
Create an Analytic View on SAP HANA DB:
Definition: Analytic View = 1Fact Table (with Key figures) + ( 1 or more Tables/Attribute views )
- Open the Tableau and create new report (Ctrl+N).
- Click Connect to Data (Ctrl+D)
- Select “SAP HANA”
- Add new connection
- Establish the connection by pressing the “Connect ” button
- Browse the Schema (Use the filter = _SYS_BIC ),
Select the Analytic (Previously created )
- Create the required report by dragging the required measures and
Conclusion: I was able to design and develop a medium complex Tableau report over SAP HANA – Analytic View n 4 Hrs.