Reporting on SAP HANA

SAP HANA is being used side-by-side to the source system. It features a data replication mechanism for SAP source systems, e.g. ERP and CRM, and an ETL (Extraction Transformation Loading) component for third party systems.

Despite its different technology, SAP HANA can be addressed as any other database using standard SQL statements. It offers JDBC and ODBC drivers which are standardized programming interfaces to access relational databases. MDX (Multidimensional Expressions) is a widespread query language for OLAP databases and is supported as well. Different reporting frontends can connect to HANA; SAP suggests using frontends of the SAP Business Objects BI Suite. Recommended frontends include SAP Business Objects Crystal Reports, Analysis Office, and Explorer.

SAP BusinessObjects Crystal Reports is a widely used tool for formatted, print-ready reporting. A very simple list created with this frontend on top of HANA data

Some accelerators offer the option to generate a virtual InfoProvider to report on SAP ERP data. A virtual InfoProvider is a BW structure, which – in this case – is generated in the embedded BW client of the ERP system. It allows you to connect BW frontends (including the ones shown above for HANA reporting) directly to ERP. The data selection takes advantage of HANA as a secondary database. In total, this gives you three accelerated reporting options for some of the scenarios:

1. Reporting in SAP ERP using the classic reporting tools (e.g. drilldown reporting)

2. Reporting via generated virtual InfoProvider

3. Reporting via HANA models