Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint

Using MDX provider in SAP HANA

What is the use of MDX provider in SAP HANA system? How this help in consumption of HANA Modeling views using BI reporting tools?


1 Answer
John SAP

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.

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.