如何在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的原創文章,請關注公眾號"汪子熙":
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2717558/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 如何在CRM WebClient UI裡使用HANA Live ReportWebclientUI
- 如何在SAP WebClient UI裡使用jChartFXWebclientUI
- 如何在SAP WebClient UI裡建立柱狀圖(bar chart)WebclientUI
- 如何在 WebClient UI 裡建立 Value HelpWebclientUI
- 如何在 SAP BTP Java 應用裡使用 SAP HANA 資料庫Java資料庫
- 在SAP WebClient UI裡顯示倒數計時的UIWebclientUI
- 使用note++開發SAP WebClient UIWebclientUI
- 在SAP WebClient UI裡使用AJAX進行非同步資料讀取WebclientUI非同步
- 在SAP CRM WebClient UI裡開啟ABAP Webdynpro頁面WebclientUI
- 如何在SAP S4HANA Cloud系統裡建立employeeCloud
- SAP HANA Delivery Unit概念簡述
- SAP WebClient UI的白屏問題分析WebclientUI
- 使用Selenium自動化測試SAP CRM WebClient UIWebclientUI
- 使用SAP Transaction Launcher將ABAP Webdynpro嵌入到WebClient UI中WebclientUI
- SAP CRM WebClient UI和Fiori UI混搭並存WebclientUI
- SAP WebClient UI overview頁面裡assignment block的可見性分析技巧WebclientUIViewBloC
- SAP WebClient UI的會話重啟原理WebclientUI會話
- Deliver projects in 100% of the time with SAP S/4 HANAProject
- SAP CRM WebClient UI上將text area裡的文字清空的後臺處理WebclientUI
- Jerry答網友提問:SAP CRM WebClient UI裡的EXT,STRUCT等含義WebclientUIStruct
- SAP HANA Cloud 學習教程之一: 如何在 SAP BTP 上建立 SAP HANA Cloud 例項Cloud
- 如何在SAP UI5應用裡新增使用攝像頭拍照的功能UI
- 如何在 SAP 電商雲 Spartacus UI 裡新建一個頁面UI
- SAP CRM WebClient UI異常的持久化機制WebclientUI持久化
- 將SAP CRM WebClient UI的表格匯出成PDFWebclientUI
- 如何將SAP WebClient UI的表格匯出成PDFWebclientUI
- 在SAP CRM WebClient UI中用javascript觸發ABAP eventWebclientUIJavaScript
- SAP WebClient UI One Hit Navigation的實現方法WebclientUINavigation
- 如何在SAP Kyma的控制檯裡擴充套件新的UI套件UI
- 如何自行分析SAP WebClient UI開發環境裡丟擲的錯誤訊息根源WebclientUI開發環境
- 使用PHP應用查詢SAP HANA Express Edition裡的資料PHPExpress
- SAP CRM WebClient UI和Hybris backoffice UI開發的相同點WebclientUI
- 如何使用Key User Tool擴充套件SAP S/4HANA Fiori UI套件UI
- 在SAP HANA Express Edition裡進行文字分析Express
- SAP CRM WebClient UI的Delta處理機制介紹WebclientUI
- SAP WebClient UI component模型後設資料解析工具WebclientUI模型
- SAP CRM WebClient UI和ABAP Webdynpro頁面的互相跳轉WebclientUI
- SAP CRM WebClient UI html 格式的 Text 顯示邏輯WebclientUIHTML