Reporting in SAP HANA
SAP HANA features side-by-side data replication mechanism for SAP source systems such as ETL, ERP and CRM for third party systems. Although it’s different technology, SAP HANA can be deal with any other database with standard SQL statements. It offers JDBC and ODBC drivers which are identical programming interfaces to access relational databases. MDX (Multidimensional Expressions) is an extensive 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.
Some accelerators offer the option to generate a virtual InfoProvider to report on SAP ERP data. A virtual InfoProvider is a BW structure, in this case is generated in the embedded BW client of the ERP system. It allows you to connect BW frontends 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:
- Reporting in SAP ERP using the classic reporting tools (drilldown reporting)
- Reporting via generated virtual InfoProvider
- Reporting via HANA models
Currently there are number of tools and applications which can be used for reporting in SAP HANA. SAP suggests using frontends of the SAP Business Objects BI Suite. Recommended frontend tools include SAP Business Objects Crystal Reports, Analysis Office, and Explorer.
Reporting on SAP HANA can be done in most of SAP’s Business Objects BI Suite of applications, or in tools which can create and consume MDX queries and data.
SAP Business Objects BI Suite as a collection of different front-end tools provided by SAP. Most important of them are
- SAP Business Objects Analysis
- SAP Business Objects Explorer
- SAP Lumira
- SAP Business Objects Crystal Reports
- SAP Business Objects Dashboards