Using MDX provider in SAP HANA

MDX provider is used to connect HANA with different reporting tools like MS Excel. MDX provider provides drivers to connect HANA system to Excel and supports data modeling. You can use Microsoft Office Excel 2010/2013 for connectivity with HANA for both 32 bit and 64 bit Windows.

To connect HANA system using MDX provider, you have to navigate to “Other Sources” in MS Excel and select SAP HANA MDX Provider in the list.

You have to provide HANA host name, instance number and authentication details to setup a connection between MS Excel and HANA Modeling views.

John SAP

Published on 09-Apr-2018 20:11:28

• Related Questions & Answers
• Use of SQL/MDX processor in SAP HANA Index server
• Using aggregated in SAP HANA
• Using SAP HANA Cockpit for HANA Administration
• How to extract data from SAP using .NET provider.
• Using parallel processing in SAP HANA
• Using temporary license in SAP HANA
• Using Analytic View in SAP HANA
• Using packages in SAP HANA studio
• Using Attribute view in SAP HANA
• Using Text join in SAP HANA
• Using database view in SAP HANA
• Using Delivery unit in SAP HANA
• Using Delivery unit in SAP HANA
• Using Information composer in SAP HANA
• Using IC_PUBLIC role in SAP HANA