SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Overview
+
-
SAP HANA Architecture
+
-
SAP HANA Studio
+
-
Reporting in HANA
+
-
SAP HANA Text analysis
+
-
SAP BW on HANA
+
-
Miscellaneous
+
-
SAPUI5

Build Reports in Excel using HANA

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.

Prerequisite:
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

Note: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:

  1. Open Excel.
  2. Go to the Data tab, and click on From Other Sources, then From Data Connection Wizard, as shown:

    SAP HANA Report in Excel

  3. Select Other/Advanced, then SAP HANA MDX provider, and then click Next.

    SAP HANA Report in Excel

  4. 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).

    SAP HANA Report in Excel

  5. 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.
    SAP HANA Report in Excel

  6. Click on the name of the analytic view or calculation view. Click "Finish".

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

    SAP HANA Report in Excel

  8. Click on the Finish button to create the connection to SAP HANA, and your View.
  9. 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.

    SAP HANA Report in Excel

Congratulations! You now have your reporting application available in Microsoft Excel.

Continue reading:

Support us by sharing this article.



Explore More
Close X
Close X

9 thoughts on “connect sap hana from Excel

  1. Balaji says:

    hi guys,

    Nice Demo with example,
    I am created successfully and able to view the report n excel
    Great!!!thanks for your demo,
    we can expect more examples from your team

  2. Adil says:

    How can i create the distinct count measure in the analytics view and make it consumable in Excel? Secondly, how about creating YTD calcs in analytic view so that it will be available in Excel?

    • Admin says:

      Hi Adil,
      The DISTINCT operator is not available in Analytic view. However you can achieve this with the help of GROUP BY clause.

      Note that the 2 below queries are equivalent.
      SELECT DISTINCT COLUMN1 FROM TABLE;
      SELECT SUM(COLUMN1) FROM TABLE GROUP BY COLUMN1;

      What do you mean by YTD calcs?

      • adil says:

        Thanks for the response. What i mean by YTD calcs is Wtd, Mtd and Ytd values for this year as well as for the last year? Is there any built in function that can be used for inventory calcs like stocks.

  3. Muhammad Ali Yaqoob says:

    Hey,

    How do i make multiple columns/fields stacked up or grouped in one folder when viewed on Excel Pivot?

  4. Vahid says:

    Hi Admin
    when I click on HANA Developer Edition-SAP HANA Client and select version 64 bit for windows and click I agree it goes to sap store and nothing for download.

    Thanks,

  5. Arsalan says:

    Facing the same issue, it takes to the store instead of downloading the file.

  6. Thorsten says:

    SAP HANA Client is not available any more or cannot be downloaded. Any ideas how to make Excel ready to use MDX with SAP HANA?

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy