bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!
×
UPTO
50%
OFF!

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.
top

Sales Offer

  • To avail this offer, enroll before 21st October 2017.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
Learn offer banner( Diwali)

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