Uses Microsoft Excel and its PivotTables to access and analyze SAP HANA data. SAP HANA supports various versions of Microsoft Excel including 2007, 2010, 2013, 2016 and Excel for Microsoft 365. The BICC maintains two SAP HANA Cubes that can be analyzed using Excel PivotTables:
A SAP HANA Cube is a type of SAP HANA “Calculation View”. A calculation view is a flexible information view that you can use to define more advanced slices on the data available in the SAP HANA database. A calculation view can include any combination of tables, views, and you can create joins, unions, and aggregations. Calculation views can include measures and be used for multidimensional reporting, or can contain no measures and used for list-type reporting.