Access Calculation View in Microsoft Excel
This post describes on viewing the reports in excel which are based on data from a calculation view in HANA database.
Apart from this, you can also view the data in SAP BOBJ and BW.
For accessing in excel, you need to have the SAP HANA Client Package for Microsoft Excel, which is part of SAP HANA Appliance.
You can get the installation instructions from the corresponding documentation. Once the package is installed, the SAP HANA MDX Provider should be available as OLE DB Provider in the data import wizard of excel.
You can import the data from the analytical view or calculation view into excel in the form of a pivot table.
This however is only possible when you have activated a setting on the HANA side – In the view properties in SAP HANA studio, select the configuration MULTI DIMENSIONAL REPORTING
Once the selection is established, you can see the list of available views in excel, select the one required and press ‘Next’.
The data is displayed in the form of a pivot table. You can also display it in the form of graphs and charts.
What is MDX?
As you have seen the OLE DB Provider name (SAP HANA MDX provider), the driver uses an internal mechanism based on MDX standard (Multidimensional Expressions)
MDX is a powerful database query language like SQL marketed by Microsoft. In contrast to SQL, MDX is focused on multidimensional access on a star schema type cube.
If you are familiar with MDX, you can use it via SQL console in SAP HANA studio.
For further information on this topic, please refer the documentation:
To learn more, go for complete course in HANA Modeling.