In the article SAP HANA Modeling Introduction
and SAP HANA Calculation View
we explained the basics of SAP HANA data modeling.
This article describes how to build a simple report using data stored on SAP HANA.
Download and install SAP HANA Client:
Excel can connect to SAP HANA using the MDX language in the form of pivot tables. These in turn allow users to "slice and dice" data as they require, to extract the metrics they need.
In order to make MDX connections to SAP HANA, the SAP HANA Client software is needed. This is separate to the Studio, and must be installed on the client system.
Like the Studio itself, it can be found on the SAP Service market place. Additionally, SAP provides a developer download of the client software on SDN, at the following link:
HANA Developer Edition-SAP HANA Client
Download and install the appropriate SAP HANA Client as per your operating system version and Microsoft Office installation.
If you are using a 64-bit operating system in combination with a 32-bit Office installation, then you' ll need the 32-bit version of the SAP HANA Client software.
Once the software is installed, there is no shortcut created on your desktop, and no entry will be created in your "Start" menu, so don't be surprised to not see anything to run.
Connect to SAP HANA from Excel:
Congratulations! You now have your reporting application available in Microsoft Excel.
- Open Excel.
Go to the Data tab, and click on From Other Sources, then From Data Connection Wizard, as shown:
Select Other/Advanced, then SAP HANA MDX provider, and then click Next.
The SAP HANA Logon dialog will appear, so enter your Host, Instance, and login information (the same information you use to connect to SAP HANA with the Studio).
Click on Test Connection to validate the connection. If the test succeeds, click on OK to choose the Modeling views to which you want to connect. Select the package which contains the modeling views.
Click on the name of the analytic view or calculation view. Click "Finish".
On this screen there's a checkbox Save password in file - this will avoid having to type in the SAP HANA password every time the Excel file is opened - but the password is stored in the Excel file, which is a little less secure.
Click on the Finish button to create the connection to SAP HANA, and your View.
Now that you have established your connection to the SAP HANA database and specified the data that you want to use, you can start exploring it in Microsoft Excel, using a pivot table.