Skip to Content

1. Log on WebUI with role ANALYTICSPRO.

/wp-content/uploads/2015/08/clipboard1_777790.png

create a new HANA live report:

/wp-content/uploads/2015/08/clipboard2_777818.png

report type choose “SHL”:

/wp-content/uploads/2015/08/clipboard2_777818.png

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

/wp-content/uploads/2015/08/clipboard3_777820.png

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

/wp-content/uploads/2015/08/clipboard4_777824.png

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:

/wp-content/uploads/2015/08/clipboard5_777825.png

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

/wp-content/uploads/2015/08/clipboard6_777826.png

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

/wp-content/uploads/2015/08/clipboard7_777828.png

The three mandatory parameters are defined in HANA studio:

/wp-content/uploads/2015/08/clipboard4_777824.png

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

/wp-content/uploads/2015/08/clipboard5_777825.png

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

/wp-content/uploads/2015/08/clipboard6_777826.png

Add measure ( Measures are measurable analytical elements ):

/wp-content/uploads/2015/08/clipboard8_777835.png

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

/wp-content/uploads/2015/08/clipboard9_777839.png

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

/wp-content/uploads/2015/08/clipboard10_777840.png

response:

/wp-content/uploads/2015/08/clipboard11_777841.png

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

/wp-content/uploads/2015/08/clipboard12_777842.png

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

/wp-content/uploads/2015/08/clipboard13_777843.png

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.


To report this post you need to login first.

1 Comment

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

Leave a Reply