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:
- Open the Tableau and create new report (Ctrl+N).
- Click Connect to Data (Ctrl+D)
Step3:
- 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
dimensions.
Conclusion: I was able to design and develop a medium complex Tableau report over SAP HANA – Analytic View n 4 Hrs.
Thank you
Great technical info. Thank you
thank you
Thanks.. Nice document.
Tanks...Nice Document.