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)

  • 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

/wp-content/uploads/2014/06/prerequisite_472967.jpg

2         Data Flow Diagram

main.JPG

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.

/wp-content/uploads/2014/06/hanastu_473024.jpg

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

/wp-content/uploads/2014/06/h1_2_473036.png

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

H1.png

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

/wp-content/uploads/2014/06/h2_473043.png

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

/wp-content/uploads/2014/06/h3_473044.png

  • Here is the output of the calculation view SALES_ORDER_ITEM_QUERY.

/wp-content/uploads/2014/06/h4_473057.png

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.

/wp-content/uploads/2014/06/h5_473058.png

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


/wp-content/uploads/2014/06/h7_473059.png

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


/wp-content/uploads/2014/06/h8_473060.png

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

/wp-content/uploads/2014/06/h9_473061.png

/wp-content/uploads/2014/06/h11_473066.png

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


/wp-content/uploads/2014/06/h12_1_473067.png

/wp-content/uploads/2014/06/h12_2_473068.png

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

/wp-content/uploads/2014/06/h12_473075.png

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

/wp-content/uploads/2014/06/h13_473076.png

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



/wp-content/uploads/2014/06/h14_473077.png

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.

/wp-content/uploads/2014/06/h15_473078.png

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

/wp-content/uploads/2014/06/l1_473079.png

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

/wp-content/uploads/2014/06/l2_473080.png

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

/wp-content/uploads/2014/06/l3_473084.png

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

/wp-content/uploads/2014/06/l4_473085.png

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.

/wp-content/uploads/2014/06/w1_473086.png

/wp-content/uploads/2014/06/w2_473087.png

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.

/wp-content/uploads/2014/06/ip6_473088.png

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

/wp-content/uploads/2014/06/ip7_473089.png

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.

/wp-content/uploads/2014/06/ip4_473090.png

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


/wp-content/uploads/2014/06/ip5_473091.png

  • Finally analyse the report is displayed in Ipad.


final.JPG

To report this post you need to login first.

30 Comments

You must be Logged on to comment or reply to a post.

  1. vijaykumar ijeri

    Hi Mohammad,

    Thanks this really nice document.

    So once I have deployed these HANA Live models, are there any preconfigured webi and other BO reports which could be deployed directly on top these HANA Live models?

    Thanks & Regards,

    Vijay

    (0) 
    1. Mohammad Safiullah Post author

      Hi Vijay ,

      If you have a look at the HANA Live Browser , there are icons like self-service BO tool i.e Lumira and SAP BO Analysis tool for analysis. As of now there are no preconfigured webi but I guess SAP is still working on it in order to make it more convenient for end users.

      I hope I have answered your queries .

      Thanks & Regards

      Mohammad Safiullah

      (0) 
  2. David Sonnenschein

    Very helpful and useful document.  It would be great to drill into some of the fine points of assembling the vdm content with external (still in HANA, just not part of the vdm) content.

    (0) 
  3. Vaithi Ramadoss

    Mohammad, Good details.

    1. I am assuming your schema for ECC is “SAP_ECC”

    2. You are not copying all the dependent views into the local package

    In our case

    1. We have our ECC tables stores in “ECC” schema

    2. Let us say I am copying SalesOrderHeader to my local package and also copied the sub view SalesDocumetnHeader

    3.  Used “Change Authorizing Schema” to repoint schema “SAP_ECC”  to “ECC”

    But still SalesDocumetHeader is referencing to sap\hba\ecc package instead of my local package.

    How can i point it to my local package? Edit the view XML?  any other options?

    (0) 
  4. Zeenath Syeda

    Thanks for sharing . Can you please share the link /document to install SAP HANA Live RDS( ECC -FI) (Step by step Guide ) . 

    Especially around Download < Extract Content < Command Prompt Settings < Import Hana studio < Set up Roles < Activate CV’s etc .

    Does the View Browser delivered by default along with the HANA Live installation or do we  install explicitly  to view the Table fields/Mapping  .

    Best Regards

    Zeenath

    (0) 
  5. syam srikanth

    Excellent Document Mohammad sir…

    Its very helpfull for us..

    Regarding this i have doubt sir . which BI content i should download for SD and MM related things…

    plz suggest me the right path sir

    (0) 
  6. Vivek Sharma

    Hi

    Thanks and appreciate the time you have put into this post.

     

    I had few queries:

    • Does HANA live works with Suite on Hana i.e. ECC 6.0 on HANA database
    • how will be the business user be able to use this application for reporting
    • Do we need any additional  application or just having SOH and HANA Live will do the job
    • Finally what kind of skill sets you think would be required to accomplish this kind of engagement

    Will appreciate a prompt response.

     

    Vivek

    (0) 

Leave a Reply