O'Reilly logo

Real Time Analytics with SAP HANA by Vinay Singh

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

Using Microsoft Excel as a reporting tool

Typically, customers / end users use different reporting tools in a business environment. But since Microsoft is widely used across user groups, it let's you see how we can expose our SAP HANA information model via Microsoft Excel.

The following are the steps to access the HANA views on Microsoft Excel:

  1. Go to Microsoft Excel 2010 or above.
  2. Go to Data | From Other Sources | From Data Connection Wizard.
    Using Microsoft Excel as a reporting tool
  3. From the data connection wizard, choose Other/Advanced:
    Using Microsoft Excel as a reporting tool
  4. In the next pop up, it asks you to choose the SAP HANA ...

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