How to Report on SAP HANA?
The output can be seen in HANA Studio after the modeling view (attribute view, analytic view and calculation view) is generated in SAP HANA. Ultimately, the manager, board members or the sales executive will ingest the modeling views to imagine various business scenarios. Since requesting a non-technical user to apply HANA Studio is unreasonable; due to which distinct reporting tools are used that can link to SAP HANA by taking the data from modeling views and display in a pleasant, simple to understand setup.
Presently there are several tools and applications which are used for reporting in SAP HANA. SAP advises using frontends of the SAP Business Objects BI Suite. Suggested frontend tools consist of Analysis Office, SAP Business Objects Crystal Reports, and Explorer.
In most of SAP' Business Objects BI Suite of applications, or in tools that create and ingest MDX queries and data, the reporting on SAP HANA can be done.
For reporting on SAP HANA Microsoft Excel can also be used
To connect to SAP HANA, access the modeling views and slice and dice the data to make meaningful reports, Microsoft Excel can also be used.
Please note that SAP Business Objects BI Suite is a group of various front-end tools offered by SAP. Some of the significant ones are listed below:
- SAP Lumira
- SAP BusinessObjects Analysis
- SAP BusinessObjects Explorer
- SAP BusinessObjects Dashboards
- SAP Business Objects Crystal Reports
SAP HANA Reporting - Clients and Connectivity Options:
Various connectivity options such as MDX, SQL, BICS etc. are backed by SAP HANA. To access relational databases, it provides JDBC and ODBC drivers which are consistent programming interfaces.
Various connectivity options maintained for frontend tools and SAP HANA:
ODBO - OLE DB for OLAP
1. For multidimensional (MDX) reporting, microsoft-driven specification
2. Via MDX (MultiDimensional eXpression language), requests are directed to the database
ODBC - Open DataBase Connectivity
1. For interactive reporting Microsoft-driven specification
2. Through SQL (Structured Query Language) database requests are made
3. In industry it is heavily adopted
4. Unix and Linux drivers exist; it is no longer Microsoft-centric
JDBC - Java DataBase Connectivity
1. Interactive reporting drivers stated by the community of Java. Common on Unix platforms.
BICS - BI Consumer Services
1. On multidimensional reporting objects, SAP Proprietary interface provides benefits for OLAP access over MDX
2. Popular driver technology utilized by SAP BusinessObjects Analysis, Office Edition for connectedness to SAP NetWeaver BW
The SAP native database SDK is SQLDBC
MS Excel: To connect to HANA using ODBO driver and MDX interaction language, MS Excel can be used. The SAP HANA Models that has the property as ‘Cube’ in semantics (like Analytic Views and Calculation Views) can be accessed with MS Excel; however, attribute views cannot be accessed using MS Excel.
SAP BusinessObjects Business Intelligence Platform tools: SAP BusinessObjects Business Intelligence (BOBI) platform is a scalable, flexible, and dependable solution for supplying collaborative reports to end users through any web application. This platform provides a resolution for enhancing the productivity of the end-user and for reducing administrative efforts.
Information Design Tool or IDT: This is a SAP BusinessObjects metadata design environment used for creating and deploying UNX universes to allow a designer to abstract, describe, and operate metadata from relational and OLAP sources.
Read more about SAP HANA Database Architecture Overview