- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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 Delivery unit in SAP HANA
- Using Delivery unit in SAP HANA
- Using Information composer in SAP HANA
- Using IC_PUBLIC role in SAP HANA
- Using database view in SAP HANA
- Using Schema mapping in SAP HANA
- Using parallel processing in SAP HANA
- Using packages in SAP HANA studio
- Using Attribute view in SAP HANA
- Using temporary license in SAP HANA
- Using Analytic View in SAP HANA

Advertisements