如何在SAP WebClient UI里使用HANA Live report
(1) Log on WebUI with role ANALYTICSPRO.
create a new HANA live report:
report type choose “SHL”:
in popup window, you have to specify the following three attributes:
For field “SAP HANA Live Query”, You can choose from F4 value help:
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:
So the query ID I choose, “OpportunityService”, actually points to the HANA query OpportunityQuery.xsodata:
(3) Now you are asked to specify value for mandatory parameters of the HANA query you select from step2.
The three mandatory parameters are defined in HANA studio:
You can find the example OpportunityQuery via the path in System perspective in HANA studio: sap->hba->crm->Calculation Views.
define an attribute for report ( Attributes are the individual non-measurable analytical elements). Here I choose “Analysis Phase”.
Add measure ( Measures are measurable analytical elements ):
(4) Now the report can be rendered – all the data comes from HANA database retrieved by HANA query efficiently:
In Chrome development tool, you can observe how analytic data is retrieved by HANA query:
response:
And the response data is also displayed in the bottom part of report:
You can switch to different stype of graph via the “Select Chart Type” drop down list.
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.ui.base.Object 的简要介绍
- SAP UI5 sap.ui.layout.Grid 控件宽度百分比的设置原理
- SAP UI5 应用中的 sap.ui.require 使用场景
- 关于 SAP 电商云 Spartacus UI Navigation Service 执行的一些明细
- SAP UI5 sap.ui.Device.media.RANGESETS 的使用介绍
- SAP UI5 sap.ui.Device.media.initRangeSet 方法的单步调试
- SAP Spartacus UI 通过 HTTP Interceptor 给请求添加 Authorization 字段的源代码分析
- 使用 Azure SNAT 为 SAP Commerce Cloud 的 outbound connection 进行端口映射
- 通过一个实际例子,理解 SAP UI5 sap.ui.model.odata.v2.ODataModel API 中 BindingContext 绑定上下文的概念和用法试读版
- 什么是 SAP ABAP FDA - Fast Data Access 技术?
- 如何根据 SAP Fiori UI 界面上的错误消息,找到后台 ABAP 对应的消息 ID 试读版
- SAP Fiori 3 的 Quartz Theme 在 WebClient UI 和 SAPGUI 中的应用
- Oracle购买SAP: 开启新数据时代(oracle收购sap)
- SAP资产明细报表详解编程语言
- SAP MD04详解编程语言
- SAP中委外采购订单发料详解编程语言
- sap*/ddic的密码破解完整篇详解编程语言
- 深度比较:SAP vs Oracle(sap与oracle比较)
- 数据库解决方案如何使用SAP创建Redis数据库(sap怎么创建redis)
- 探索 Oracle 与 SAP 技术的开发可能性(oracle sap开发)