About this Document
This manual aims to help you to understand the modeling of HANA Live Views and reporting based on customized HANA models in SAP BO Web Intelligence and SAP Lumira and analyzing in IPad (mobile devices). This kind of processing is done in SAP Business Suite on HANA. This manual also provides details of the steps involved in modeling views on SAP predefined HANA Live views and creating real time operational report based on HANA views. This document is created solely with the intention of sharing information.
1 Overview of HANA Live
1.1 Views in Virtual Data Model (VDM)
1.1 Do’s and Don’ts (if any)
1.1 Pre-requisites for HANA live Installation
2 Architecture of the Document
3 Modeling in HANA studio
4 HANA Live Browser.
5 Visualization in Lumira
6 Reports in Web Intelligence
7 Analyzing in IPad
1 Overview of HANA Live
SAP HANA Live provides SAP-delivered content for HANA calculation views for real-time operational reporting and is the platform for the new native SAP HANA applications Smart Business.
The content is represented as a VDM – virtual data model, which is based on the transactional and master data tables of the SAP Business Suite. The SAP HANA Studio provides the Calculation views for these VDM.
1.1 Views in VDM (Virtual Data model)
- Private Views
- Reuse Views
- Query Views
- The SAP HANA Live scenario as delivered contains “Private Views” which are the base views that directly use the SAP Tables.
- The next level of views is the “Reuse Views” which consist of one or more “Private” views joined in combination to produce a composite view that forms a reusable unit related to a particular area or function within the system.
- The top level of views is the “Query Views” which consist of one or more “Reuse” views joined in combination to expose the major attributes and measures that are needed to report on the various business scenarios
- These “Query Views” are the only views that are exposed to the Client Tools to be used for reporting.
- SAP HANA Live is now delivering 2000+ HANA virtual data model views and will continue to grow this number.
- Since all of these different types of views are based on Standard SAP tables, they do not include any custom fields that may have been added to these tables in the SAP system, nor do they contain any custom tables that may have been added. The standard “Query Views” generally also contain more fields than are required for any particular reporting scenario.
- Customers will not be allowed to change SAP delivered views, however as mentioned previously, they can always build on top of these views. The first bottom four layers are meant to be stable and approved by SAP as a certified interface to the Suite data structures.
- One more thing to keep in mind, all views in the VDM are Calculation Views. There is no Attribute or Analytic Views developed as part of the VDM.
1.3 Do’s and Don’ts (if any)
- A Query View must not be consumed by another view. It is always the top view in a hierarchy of views.
- Query Views are visible for SAP Business Objects front-end tools. Currently this is achieved via the flag “multidimensional reporting”. This is enabled automatically as soon as a measure or counter exists. It is intended to enable/disable visibility for MDX consumers manually.
- For Query Views customers can define analytical privileges and assign them to roles or users to ensure proper authorization checks.
- Reuse and Private views are not consumed directly by analytical applications or a generic analytical tool.
- These views are usually consumed by another view, also by a Query View.
- For other views, customers should never grant SQL select privileges to business users.
1.4 Pre-requisites for HANA Live installation
2 Data Flow Diagram
3 Modeling in HANA Studio
We will now see the basic steps of modeling customized view using Query view in Suite on HANA.
- Login to HANA Database via HANA Studio by clicking add system.
- Next according to the requirement ,we have to do some modification. We want to add a reuse view SalesDistrict and some measures from reuse view SalesOrderItem to output for further analysis. But it is not recommended to do any modification on the predefined query view. So, Add to Output is disabled.
- Therefore, we created a calculation view SALES_ORDER_ITEM_QUERY by copying ECC HANA Based Analytics (HBA) query view SalesOrderItemNetAmountQuery in other package as it is recommended .
- Note : Make sure the package has privilege to create views and we can access it through HANA live browser.
- We added certain measure attributes like ItemGrossWeight, ItemNetWeight, ItemVolume, OrderQuantity and so on to the output in the calculation view SALES_ORDER_ITEM_QUERY.
- We also added a reuse view to include SalesDistrictName attribute to the output in the calculation view SALES_ORDER_ITEM_QUERY.
- Here is the output of the calculation view SALES_ORDER_ITEM_QUERY.
4 HANA Live Browser
We will now see the basic steps of analyzing customized view using Hana Live Browser.
- Login to HANA Database via Hana Live browser.
- By Default, all the views are categorized according to application component like BC, CA, and FI and so on .In order to see the customized calculation view, we select the package hierarchy.
- Next we navigate to customer package and select the customized calculation view SALES_ORDER_ITEM_QUERY.
- We can also see all the predefined views are categorized according to Query, Reuse and Private views in sap->hana->hba->ecc.
- Select customized calculation view SALES_ORDER_ITEM_QUERY and click open content to see the data .
- Select customized calculation view SALES_ORDER_ITEM_QUERY and click cross reference the source of data .
- Then select graphical view to see of data from tables .
- We can analyze the customized calculation view SALES_ORDER_ITEM_QUERY in SAP Lumira which is self Sevice BI Component and Analysis office.
- Select customized calculation view SALES_ORDER_ITEM_QUERY and click Lumira component.
- As soon as we select the Lumira Component, SAP Lumira Connection File (.svic) for SALES_ORDER_ITEM_QUERY will be downloaded.
5 Visualizations in SAP Lumira
We will now see the basic steps of creating a report on customized view using SAP Lumira.
- Click the SAP Lumira Connection File (.svic) for SALES_ORDER_ITEM_QUERY.
- Enter the credentials in order to connect to HANA Database.
- Next we created four visualization using different KPI’s and thus created a dataset named SALES ORDER ITEM ANALYSIS.
- We added sales order dimension to further analyze different visualization in the dataset SALES ORDER ITEM ANALYSIS.
- Finally we saved dataset SALES ORDER ITEM ANALYSIS in the SAP Lumira Cloud.
- We can share the dataset SALES ORDER ITEM ANALYSIS in the SAP Lumira Cloud with other user having an account in SAP Lumira Cloud.
6 Reports in Web Intelligence
We will now see the basic steps of creating a report on customized view using Web I.
- Next we created a universe on top of customized view.
- Thus we created SALES ORDER ITEM ANALYSIS REPORT in Web I and saved in BI Launch pad.
7 Viewing in IPad
We will now see the basic steps of viewing the Web I report on customized view in IPad.
Configuration in BI launch IPad:
- Go to BI launch Pad and navigate to the folder where Web I report is saved.
- Right click the report and select categories.
- Select the corporate categories->mobile and click ok .
- Go to app store on IPAD/IPhone and search for “SAP BI” app and download and install it.
- Open the SAP BI mobile app on your IPAD/IPhone.
- Click on Connect button>Go to Add a connection option and choose create manually.
- Enter your Business Objects server details to configure connection to your BI platform.
- Click on done to save the connection.
- On the Home page of the app, click on connect button again and choose connection name to attempt connection, once this connection is successful it shows connection icon in green along with listing SAP User ID.
- Finally analyse the report is displayed in Ipad.