O'Reilly logo

SAP HANA Cookbook by Ganesh Mahadevan V., Chandrasekhar Mankala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating reports using Microsoft Excel

Though many reporting tools are available on the market, many users still use MS Excel to report. In this section, we will cover analysis of data from SAP HANA in Excel.

Getting ready

Microsoft Excel can also be used to consume data from SAP HANA and act as a reporting tool for users. Excel is still used as a reporting tool in many parts of the BI world to access and analyze data.

How to do it…

Let's create a connection to SAP HANA. Follow the given steps:

  1. From the Data tab, select From Other Sources. This will open a pop up with all the available OLE DB provider types. Scroll down and select SAP HANA MDX Provider from the list and then click on the Next button, as shown in the following screenshot:
  2. Now, provide ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required