如何在SAP WebClient UI裡使用HANA Live report

i042416發表於2020-09-07

(1) Log on WebUI with role ANALYTICSPRO.


如何在SAP WebClient UI裡使用HANA Live report


create a new HANA live report:


如何在SAP WebClient UI裡使用HANA Live report


report type choose “SHL”:


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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:


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


The three mandatory parameters are defined in HANA studio:


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


Add measure ( Measures are measurable analytical elements ):


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


response:


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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


如何在SAP WebClient UI裡使用HANA Live report


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

a. 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. b. URLs with the path /sap/opu/odata/sap/ are routed to the message server for the CRM system.

要獲取更多Jerry的原創文章,請關注公眾號"汪子熙":

如何在SAP WebClient UI裡使用HANA Live report


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2717558/,如需轉載,請註明出處,否則將追究法律責任。

相關文章