Connecting to Excel with HANA
Using Excel to Display HANA Data (Microsoft Excel 2010)
Data –> From Other Sources –> From Data ConnectionWizard –>
Other/Advanced –> Next
SAP Hana MDX Provider –> Next
Enter Credentials to log into HANA
Test Connection to ensure that the connection is working.
Select the Database Table that you want to analyse.
Drag and Drop the Characteristics and Key Figures into the Rows and Columns.