Setting up HANA Connectivity to Excel
The first step is to create a connection between Excel and HANA is to Download SAP HANA Client for Excel from the SAP Service Marketplace. This can be found by going to Products – Software Downloads – Support Packages & Patches – Alphabetical List of Products – SAP HANA Platform Edition. From here, you can search based on Entry by Component and select SAP HANA Client for Excel. The next step is to Install the SAP HANA Client for Excel by opening the EXE file that you downloaded in the steps above. After this, you will only need to follow the simple steps in the Installation Wizard. Once the Installation is complete open a Blank Workbook in Excel. If you previously had Excel open during the Installation Wizard please close and reopen. Next, go to the Data Tab, click the From Other Sources dropdown and select From Data Connection Wizard. After that is done, select Other/Advanced and click Next.
The next screen will bring up the Data Link Properties Window, and on the Provider Tab you will select SAP HANA MDX Provider and click Next. The next screen is the Connection Tab where you will need to enter your SAP HANA Host, Instance Number, and Login Credentials. After you have entered these details, click Test Connection to make sure the Test Connection has succeeded. Once this is done, click OK.
The next screen allows you to select from the dropdown which Package the HANA Model you want to report from exists in. After selecting the Package, click the Analytic or Calculation View that you want to report from and click next. On the next screen, you enter the details for a connection file that can be used later to connect to the same data source without having to go through the Data Connection Wizard again. Once a Connection File has been saved, you can open this connection anytime you want by going to the Data tab and clicking Existing Connections. Once the Wizard has completed, you can select how you would like to Import the Data. From here you can create Pivot Tables, Pivot Charts etc. to analyze the data based on the HANA Model you have selected.