In the previous article SAP HANA Live Overview – part 1
, we explained the basic features and functionalities of HANA Live.
In this article, we will see some more important points about HANA Live.
Deployment Options for HANA Live:
There are 2 deployment options for HANA Live.
In the side-by-side scenario, the database tables that are used by the SAP HANA Live products need to be replicated from the corresponding SAP Business Suite back-end system into the SAP HANA database. This is done using SAP Landscape Transformation Replication Server. If you want to execute SAP HANA Live views, the data from the corresponding tables must be available.
SAP recommends to create all required tables as specified in the SAP Notes corresponding to the SAP HANA Live products, and to replicate the data only for those tables that are used in executed analytical scenarios. This ensures that no unnecessary data is replicated, that no unnecessary SAP Landscape Transformation Replication Server resources are consumed, and that no unnecessary DB memory is consumed.
In the integrated scenario, you do not need to create and replicate the database tables, as they are already available in the SAP HANA database. They are maintained through the data dictionary of the corresponding ABAP Application Server. Therefore, all steps regarding table creation and data replication are not relevant in this scenario.
Since the ABAP server creates all tables in one specific database catalog schema (typically <SAPSID>), this needs to be mapped to the authoring schema of the imported content packages.
See Schema Mapping
Frontend tools for HANA Live reporting:
SAP HANA Live reports can be accessed by HTML 5, native Excel or SAP BusinessObjects Business Analytics applications.
Following SAP BusinessObjects analytical solutions are recommended:
- SAP Crystals Reports for Enterprise 4.0.4
- SAP BusinessObjects Analysis (Edition for Microsoft Office) 1.0.3
- SAP BusinessObjects Explorer
- SAP BusinessObjects Dashboards 4.0.4
- SAP Lumira
Backend tools to access HANA Live views:
HANA Live back-end can be accessed using the SAP HANA Studio. We can also use html-based SAP HANA Live View Browser to access the structures and elements of the virtual data model.
SAP HANA Live Tools:
SAP HANA Live Browser:
With this application you can quickly and easily search, browse, tag and consume HANA analytical content views using an internet web browser. This application is available as an option for business users who want to consume HANA content views or preview data without using HANA studio.
You can access the application using the URL http://<HANA Server Host>:80<SAP HANA Instance Number>/sap/hba/explorer
SAP HANA Live Authorization Assistant:
With the SAP HANA Live Authorization Assistant, you can provide users authorizations in the SAP HANA system that is required to access business data displayed by the virtual data model of SAP HANA Live.
SAP HANA Live Authorization Assistant is used to manage both the analytical privileges that are restricting access to specific business data, and the object privileges that are controlling the database views the user uses to report.