Step-by-step guide to implement HANA Live Modeling Scenarios

  • A+
所属分类:数据分析

About this Document

Purpose

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.

Contents:

1       Overview of HANA Live

1.1          Views in Virtual Data Model (VDM)

1.2          Limitation

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

Key features:

  • 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.

1.2      Limitation

  • 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)

  • 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

Step-by-step guide to implement HANA Live Modeling Scenarios

2         Data Flow Diagram

Step-by-step guide to implement HANA Live Modeling Scenarios

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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Therefore, we created a calculation view SALES_ORDER_ITEM_QUERYby copying ECC HANA Based Analytics (HBA) query viewSalesOrderItemNetAmountQuery 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • We added certain measure attributes like ItemGrossWeight, ItemNetWeight, ItemVolume, OrderQuantity and so on to the output in the calculation view SALES_ORDER_ITEM_QUERY.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • We also added a reuse view to include SalesDistrictName attribute to the output in the calculation view SALES_ORDER_ITEM_QUERY.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Here is the output of the calculation view SALES_ORDER_ITEM_QUERY.

Step-by-step guide to implement HANA Live Modeling Scenarios

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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Select customized calculation view SALES_ORDER_ITEM_QUERY and click open content to see the data .

Step-by-step guide to implement HANA Live Modeling Scenarios

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Select customized calculation view SALES_ORDER_ITEM_QUERY and click cross reference the source of data .

Step-by-step guide to implement HANA Live Modeling Scenarios

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Then select graphical view to see of data from tables .

Step-by-step guide to implement HANA Live Modeling Scenarios

  • 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • As soon as we select the Lumira Component, SAP Lumira Connection File (.svic) for SALES_ORDER_ITEM_QUERY will be downloaded.

Step-by-step guide to implement HANA Live Modeling Scenarios

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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Next we created four visualization using different KPI’s and thus created a dataset named SALES ORDER ITEM ANALYSIS.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • We added sales order dimension to further analyze different visualization in the dataset SALES ORDER ITEM ANALYSIS.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Finally we saved dataset SALES ORDER ITEM ANALYSIS in the SAP Lumira Cloud.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • We can share the dataset SALES ORDER ITEM ANALYSIS in the SAP Lumira Cloud with other user having an account in SAP Lumira Cloud.

Step-by-step guide to implement HANA Live Modeling Scenarios

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.

Step-by-step guide to implement HANA Live Modeling Scenarios

Step-by-step guide to implement HANA Live Modeling Scenarios

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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Select the corporate categories->mobile and click ok .

Step-by-step guide to implement HANA Live Modeling Scenarios

IPAD Configuration:

  • 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • 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.

Step-by-step guide to implement HANA Live Modeling Scenarios

  • Finally analyse the report is displayed in Ipad.
    Step-by-step guide to implement HANA Live Modeling Scenarios

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

目前评论:1   其中:访客  1   博主  0

    • ag

      原文章:https://blogs.sap.com/2014/06/11/step-by-step-guide-to-implement-hana-live-modeling-scenarios/