Skip to Content

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:

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

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.

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

2. Create a new KPI:

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

Maintain KPI id and Title:

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

in the Data source area, I just use the standard HANA view OpportunityQueryOData delivered by SAP. Click Save and Activate.

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

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 )

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

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

And for evaluation, we need to specify four mandatory parameters:

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

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.

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

Click Save and Activate, after that you should see your evaluation.

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

4. Open your evaluation just created in previous step, click “Configure Tile”:

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

Click “Add Tile”:

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

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.

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

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”:

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

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.

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

The calculation result is displayed in tile as expected:

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

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.

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

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.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply