Information required to connect MS Excel to SAP HANA

Choose SAP HANA MDX Provider from this list to connect to any MDX data source → Enter HANA system details (server name, instance, user name and password) and you need to click on Test Connection → Connection succeeded → OK

It will give you the list of all packages in drop down list that are available in HANA system. You can choose an Information view → click Next → Select Pivot table/others → OK.

SAP Expert

Published on 21-Feb-2018 16:46:27

• Related Questions & Answers
• SAP HANA roles required for using Information Composer
• Information required while creating a new Delivery Unit in SAP HANA
• Getting information in MS SharePoint workflow from SAP
• How to encrypt the MS excel workbook?
• Information required adding a new remote data source in SAP HANA SDA
• Accessing SAP HANA Information Composer
• System requirement to install SAP HANA Information Composer
• Using Information composer in SAP HANA
• Easy to use features of SAP HANA Information Composer
• Publishing data to SAP HANA database using Information Composer
• Latest MS Excel Specifications, Features and Benefits
• Object privilege required to use SAP HANA Smart Data Access
• Information available under System Monitor in SAP HANA
• Information available in M_DISKS view in SAP HANA
• Checking information about executed savepoints in SAP HANA