Flat 10% & upto 40% off + 10% Cashback + Free additional Courses. Hurry up

Sap Hana Integration With Microsoft Excel

Microsoft Excel can be integrated with SAP HANA using MDX language with the help of pivot tables. SAP HANA client software is needed to make MDX connections which should be configured in the client system. Once this client software is downloaded and installed, you ca go ahead with the following procedure:

Step 1 : Launch MS Excel and go to the Data menu.

Step 2 : Select ‘From Data Connection Wizard’ option

Sap Hana Integration With Microsoft Excel

Step 3 : Go to ‘Other/Advanced’ option and select ‘SAP HANA MDX Provider’.

Step 4 : Now, SAP HANA Login window will appear where you will provide the credentials, i.e., Host, Login, Instance, etc., and click on the ‘Test Connection’ button.

Sap Hana Excel

Step 5 : After successful completion of the test click ‘OK’ to enter into a new window asking to choose modeling views. Select the package.

Step 6 : Click on the name of analytic view or calculation and hit the ‘Finish’ button.

Step 7 : A dialog box will appear informing you about saving the password in the Excel file which will save you from entering password over and over again. Click on ‘Finish’ button and you connection with SAP HANA database is made.

Sap Hana Integrations with Excel

"0 Responses on Sap Hana Integration With Microsoft Excel"

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

Sales Offer


Sign Up or Login to view the Free Sap Hana Integration With Microsoft Excel.