HA100 Excel

Excel

******************************

Understand how MS Excel can query SAP HANA using an ODBO connection

Create a pivot tbl in MS excel using a Calculation View

BZN I.E.
Successfully deployed info models in SAP HANA Studio. You now want to see how these can be used from an end user perspective.
EXCEL not a typical client tool used, provides a simple/practical way for a modeler to troubleshoot how created information models will work for the end user.

**************************************


Understand how MS Excel Can Query SAP HANA using an ODBO connection?
MDX Reporting is available via Excel Pivot tables

• Advantages
• quick and dirty cross-tab style reporting via Excel
• Disadvantage
• report definition available locally
• performance limitations of the desktop
• Reporting on SAP HANA -Native Excel -pivot tbls(ODBO)
• ODBO driver is available via the advanced option of the data connection wizard
• Standard MS Pivot tbl interface
• checks measures, drag and drop rows/columns

Create a pivot table using a Calculation View

Excel Pivot Tbls(ODBO/MDX Access

1. Initiate the Excel data connection wizard
1. Data Ribbon --> other Sources --> Data Connection Wizard
2. Select other/advanced drivers then click Next
3. SAP HANA MDX provider  -->next
4. Connection Tab --> Test Connection
1. Host, Instance Number, User, PW, Language
5. Choose a pkg --> cube(analytic or calculation view)
1. Select pck, select calc view, next
6. Connect/save
7. Accept the pivot tbl report properties -->connect
8. Empty pivot tbl, 
1. List of fields available in the PivotTable Field List