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.