Step by Step to create HANA live report in Webclient UI

Step by Step to create HANA live report in Webclient UI

1. Log on WebUI with role ANALYTICSPRO.

Step by Step to create HANA live report in Webclient UI

create a new HANA live report:

Step by Step to create HANA live report in Webclient UI

report type choose “SHL”:

Step by Step to create HANA live report in Webclient UI

in popup window, you have to specify the following three attributes:

Step by Step to create HANA live report in Webclient UI

For field “SAP HANA Live Query”, You can choose from F4 value help:

Step by Step to create HANA live report in Webclient UI

In this example I just use standard HANA query delivered by SAP: OpportunityQuery.

2. Do not be confused by the id “OpportunityService” in previous screenshot. It is just an identifier defined in SPRO, but not the technical ID for a given HANA query view.

The 5 entries of the value help come from the below customizing:

Step by Step to create HANA live report in Webclient UI

So the query ID I choose, “OpportunityService”, actually points to the HANA query OpportunityQuery.xsodata:

Step by Step to create HANA live report in Webclient UI

3. Now you are asked to specify value for mandatory parameters of the HANA query you select from step2.

Step by Step to create HANA live report in Webclient UI

The three mandatory parameters are defined in HANA studio:

Step by Step to create HANA live report in Webclient UI

You can find the example OpportunityQuery via the path in System perspective in HANA studio: sap->hba->crm->Calculation Views.

Step by Step to create HANA live report in Webclient UI

define an attribute for report ( Attributes are the individual non-measurable analytical elements). Here I choose “Analysis Phase”.

Step by Step to create HANA live report in Webclient UI

Add measure ( Measures are measurable analytical elements ):

Step by Step to create HANA live report in Webclient UI

4. Now the report can be rendered – all the data comes from HANA database retrieved by HANA query efficiently:

Step by Step to create HANA live report in Webclient UI

In Chrome development tool, you can observe how analytic data is retrieved by HANA query:

Step by Step to create HANA live report in Webclient UI

response:

Step by Step to create HANA live report in Webclient UI

And the response data is also displayed in the bottom part of report:

Step by Step to create HANA live report in Webclient UI

You can switch to different stype of graph via the “Select Chart Type” drop down list.

Step by Step to create HANA live report in Webclient UI

Note: The prerequisite of using this solution in CRM Webui is the following configuration must be done for SAP Web Dispatcher.

  • URLs with the path /sap/hba/apps/crmhlq are routed to the OData port for the SAP HANA Extended Application Services in the SAP HANA database, which contains the SAP HANA Live Content with the query views used.
  • URLs with the path /sap/opu/odata/sap/ are routed to the message server for the CRM system.

Leave a Reply

Your email address will not be published. Required fields are marked *