When the modeling view (attribute view, analytic view and calculation view) is created in SAP HANA, you can see the output in HANA Studio. Finally it will certainly be non-technical end users (for example manager, sales executive, board members etc.) who will certainly consume the modeling views to visualize different business circumstances.
Asking a non-technical user to use HANA Studio is not really practical. You likewise would not wish to put the modeling software in the hands of all your users.
That’s why we require separate reporting tools which can link to SAP HANA, take the data from modeling views and show in a nice, easy to understand format.
Currently there are number of tools/applications which can be made use of for reporting in SAP HANA. SAP suggests utilizing frontends of the SAP Business Objects BI Suite. Recommended frontend tools include SAP Business Items Crystal Reports, Evaluation Office, and Explorer.
Reporting on SAP HANA can be performed in the majority of SAP’ Business Objects BI Suite of applications, or in tools which can produce and consume MDX inquiries and data.
Microsoft Excel can also be utilized for reporting on SAP HANA
You can utilize Excel to connect to SAP HANA, access the modeling views and slice and dice the data to create significant guides.
Inspect Build Guides in Excel making use of SAP HANA Data
Keep in mind: You can consider SAP Business Objects BI Suite as a collection of various front-end devices offered by SAP. Crucial of them are
- SAP BusinessObjects Analysis
- SAP BusinessObjects Explorer
- SAP Lumira
- SAP Business Objects Crystal Reports
- SAP BusinessObjects Dashboards
Reporting on SAP HANA – Customers and Connectivity Options:
SAP HANA supports various connectivity choices such as MDX, SQL, BICS and so on. It supplies JDBC and ODBC motorists which are standardized programs user interfaces to access relational databases.
Below image shows the different connectivity options supported for frontend tools and SAP HANA.
- ODBO – OLE DB for OLAP
- Microsoft-driven specification for multidimensional (MDX) reporting
- Requests are sent to the database via MDX (MultiDimensional eXpression language)
- ODBC – Open DataBase Connectivity
- Microsoft-driven specification for relational reporting
- Database requests are made via SQL (Structured Query Language)
- Heavily adopted in industry
- No longer Microsoft-centric – Unix and Linux drivers exist
- JDBC – Java DataBase Connectivity
- Relational reporting drivers specified by the Java community. Popular on Unix platforms.
- BICS – BI Consumer Services
- SAP Proprietary interface that offers advantages for OLAP access over MDX on multidimensional reporting objects
- Common driver technology used by SAP BusinessObjects Analysis, Office Edition for connectivity to SAP NetWeaver BW
- SQLDBC is SAP native database SDK