What is SAP HANA MDX Provider?

MDX provider is used to attaching MS Excel to SAP HANA database system. It presents driver to attach HANA device to Excel and is in addition, used for records modeling. you may use Microsoft Office Excel 2010/2013 for connectivity with HANA for both 32 bit and 64-bit Windows.

SAP HANA helps each query languages − SQLuare and MDX. each language can be used: JDBC and ODBC for SQLL. and ODBO is used for MDX processing. Excel Pivot tables use MDX as a query language to examine records from SAP HANA system. MDX is described as part of ODBO (OLE DB for OLAP) specification from Microsoft and is used for informed choices, calculations, and layout. MDX helps multidimensional statistics version and guide reporting and analysis requirement.

MDX provider enables the consumption of statistics views described in HANA studio by SAP and non-SAP reporting tools. current physical tables and schemas present the information foundation for information models.


Once you choose SAP HANA MDX provider from the list of data source you want to connect, pass HANA system details like host name, instance number, user name and password.


Once the connection is successful, you can choose Package name → HANA Modeling views to generate Pivot tables.


MDX is strongly integrated into HANA database. Connection and Session management of HANA database handles statements that are executed by HANA. When these statements are performed, they are parsed by MDX interface and a calculation model is generated for each MDX statement. This calculation model creates an execution plan that generates standard results for MDX. These results are directly consumed by OLAP clients.

To make MDX connection to HANA database, HANA client tools are required. You can download this client tool from SAP market place. Once installation of HANA client is done, you will see the option of SAP HANA MDX provider in the list of data source in MS Excel.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status