SAP HANA Excel Integration - SAP HANA

What is SAP HANA - Excel Integration?

Microsoft Excel is measured the most common BI reporting and exploration tool by many administrations. Business Managers and Analysts can attach it to HANA database to draw Pivot tables and charts for analysis.

Connecting MS Excel to HANA

Open Excel and go to Data tab → from other sources → click on Data connection wizard → Other/ Advanced and click on Next → Data link properties will open.

connecting_msexcel_to_sap_hana

data_link_properties
Choose SAP HANA MDX Provider from this list to connect to any MDX data source → Enter HANA system details (server name, instance, user name and password) → click on Test Connection → Connection succeeded → OK.
It will give you the list of all packages in drop down list that are available in HANA system. You can choose an Information view → click Next → Select Pivot table/others → OK.

select_pivot_table

All attributes from Information view will be added to MS Excel. You can choose different attributes and measures to report as shown and you can choose different charts like pie charts and bar charts from design option at the top.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP HANA Topics