Step by Step to consume HANA Query view in CRM Fiori
In CRM Fiori there is one standard application called Customer report, where you can consume the HANA query view modeled in HANA studio, taking one example below:
This blogs shows the step by step how to consume a given HANA query view in CRM Fiori.
1. log on Fiori with user which is assigned with PFCG roles /UI2/SAP_KPIMOD_TCR_S and /UI2/SAP_KPIFRW5_TCR_S.
You can get more detail from sap help.
You should see the following tiles after log on.
2. Create a new KPI:
Maintain KPI id and Title:
in the Data source area, I just use the standard HANA view OpportunityQueryOData delivered by SAP. Click Save and Activate.
3. The KPI itself could not directly be consumed by Fiori launchpad. Instead only an evaluation belonging to a given KPI could be consumed. Go back to Fiori launchpad and go to tile “KPI Workspace”. Find the KPI just created in step2 and create an evaluation based on it. ( Current Evaluation: 0 )
And for evaluation, we need to specify four mandatory parameters:
You may ask where does the definition of these four parameters come from, actually they are just defined in the underlying HANA view in HANA studio, as mandatory.
Click Save and Activate, after that you should see your evaluation.
4. Open your evaluation just created in previous step, click “Configure Tile”:
Click “Add Tile”:
Specify the following Semantic Object and Action, so that in the runtime when this tile is clicked in Launchpad, the SAP standard Fiori application “Customer Report” will be opened, which acts as the container to display the HANA Query view configured in the KPI.
5. Last step is to configure the tile created in step 4 to make it visible in Launchpad.
By default all KPI tiles created based on a given evaluation will appear in catalog “SAP : KPIs”:
Now it is ready for test. Open launchpad the the measure you specified in KPI in step 2 will automatically be calculated by smart business framework. In the roundtrip you can really observe the four parameter you specify on evaluation you have done in step 3.
The calculation result is displayed in tile as expected:
If you click the tile, all CRM WebUI reports created based on the HANA odata service OpportunityQuery would be displayed in the left part list. By selecting one of them you can navigate to report drill-down detail page.
For how to create CRM WebUI reports based on a given HANA view, please refer to this blog: Step by Step to create HANA live report in Webclient UI.