HANA Live Real Time Business Intelligence Unifying OLAP OLTP – ASUG Webcast
This ASUG webcast was similar to BI Rapid Deployment Solutions – EMEA Webcast with some updates. The usual legal disclaimer applies that things in the future are subject to change. This is part 1. Part 2 is here HANA Live RDS – Unifying OLAP OLTP for Real Time BI – Part 2 ASUG Webcast
The SAP speaker said we are moving from large complex projects. Rapid deployment solutions come in packages, for different areas. This webcast covered the SAP HANA Live rapid deployment solution, which includes software, best practices and services. The software = SAP HANA Live – on HANA platform / database. The best practices is the content in HANA Live. Services are defined with a predefined scope.
Next Generation Business Requirements for Operational Analytics
Figure 1: Source: SAP
HANA Live uses Suite on HANA. HANA Live is a by product of Suite on HANA.
HANA Live uses the tables from SAP business suite. HANA Live uses the same set of tables and replicate for analytical information
The speaker said the virtual data models are available on HANA license (enterprise edition/suite on HANA)
Figure 2: Source: SAP
Figure 2 shows data views are available with HANA Live the suite including CRM, inventory, suppliers, etc.
The speaker said there is uniformity with HANA Live, across business suite systems and applications
Figure 3: Source: SAP
SAP Business Suite powered by HANA – SAP wants to help drive business in real-time.
The speaker said always work on a single source of truth and analysis on large parts of data
SAP HANA Live provides options for operational reporting by providing over 2K virtual data models
The RDS solution provides 100 pre-built reports based on BI Platform
Users can obtain real time operational reporting on top of large amounts of data against the business suite with the HANA Live
Figure 4: Source: SAP
Architecture of HANA Live is shown above in Figure 4.
HANA Live has a “unique way of defining access to the data model and tailored to analytical use cases”.
It uses familiar tables such as MARA and BSEG
Data models for HANA Live are optimized for transaction scenarios
It uses a layered set of database views – virtual data models
Top layer provides views consumed by BI tools – query views – SAP UI5 or BI Platform
Layered views with physical tables on top of tables use private views and reused views
HANA Live is a two-tier architecture with SAP HANA using a relational database – app server and web server is first tier, and the UI clients are the second tier
Initial shipment is characterized is applications are exposing the UI5 applications on tablets and use the query views using XS engine or the virtual data models – views on database tables
Replication is only required for side by side scenario (sidecar scenario) using SLT
Top layer of model is the query view, designed to be consumed by BI clients. They can be exposed as OData services by XS engine too.
Reuse views are the heart of the virtual data model – not meant for consumption of reports – translates source business suite into views
Private views are the encapsulation of the transformations (views/joins of physical tabes)– comparable to ABAP sub routines
Figure 5: Source: SAP
Figure 5 provides definition of the HANA Live views, discussed in Figure 4.
Figure 6: Source: SAP
The speaker said they are in continuous innovation mode
The content with SAP HANA Live – go to help.sap.com you will see the out of the box content (meaning the data models for operational reporting)
Data models are available for SAP ERP, CRM and some industry specific components such as Insurance
It is in quarterly shipment mode
SP04 for HANA Live was delivered in December 2013
SP05 will be available in 2014
Figure 7: Source: SAP
Value proposition is shown above
It is an open model, can extend models based on custom applications
SQL skills are sufficient to retrieve data
It enables common reporting
Data models hide the complexity
RDS provides guides on how to extend the models.
Figure 8: Source: SAP
Common question is how does this fit with SAP Business Warehouse?
HANA Live is a tool for real time operational reporting – lightweight modeling
BW is for strategic and technical reporting; planning scenarios
This is not replacing BW, according to the speaker
To be continued…at HANA Live RDS – Unifying OLAP OLTP for Real Time BI – Part 2 ASUG Webcast