Create Your First Smart Business KPI and Tiles in 10 Minutes
In my previous articles, I explained Smart Business Service and how to subscribe it in HANA Cloud Platform.
- SAP Smart Business Service – Create Analytic Content in HCP without Coding
- How to Subscribe to SAP Smart Business Service
- SAP Smart Business Service Roles
In this article, we will do a hands-on and create a KPI and Tiles using Smart Business Service.
Start your stop watch, this would not take more than 10 minutes 😎 😎
Before creating a KPI, you need an OData service as a data source. Here we will use a OData service provided by Smart Business Service for demo purpose.
Here we will create a KPI to analyze Average Product Rating for Alpine System Supplier Company. The final result will be as below.
Note: This is just a demo data and does not give any actual information about Alpine System Company.
1. Go to Fiori Launchpad site and click on Create KPI Apps.
2. Enter KPI Title as “Average Product Rating”.
3. Go down and enter Source System as “BusinessSystem00”.
Enter OData Service as “/ssb/services/democontent/odata/smartbusiness.svc”.
Note 1 : You need to manually type the Source System name (BusinessSystem00). In next article, I will explain how to configure BusinessSystem destiantions so that it will come in value help popup.
Note 2 : If you want to use any other OData service, then configure your own BusinessSystem and use that.
4. Click on Entity Set and select “Purchase” entity. Further click on Value Measure and select “Rating”.
5. Finally click on “Activate and Add Evaluation”.
1. Enter title as For Alpine System.
2. Go down and click on “Optional Filters”.
3. Select “Supplier Company” and click on OK.
4. Click on “Values” and select Alpine System.
5. Enter following Thresholds and finally click on “Activate and Configure Tiles”
1. Click on “Add Tile” button.
2. Select Catalogs and Groups.
Note: You can add Tile to any Catalog and Group. Catalogs and Groups are used to enable role-based access to apps in Fiori Launchpad. To know more about it refer to Creating and Configuring Catalogs
3. Click on “Save and Configure Drill-down”.
1. Click on “Configure” button.
2. Select “Product name” as Dimension.
3. Select “Rating for Item” as Measure.
4. Enter “View Title” and click on “Save”.
5. Click on “Save Configuration”.
Congratulation! You have successfully create KPI, Evaluation, Tiles and Drill-down.
Check Smart Business Tile
Go to Fiori Launchpad home page and newly created Tile should be available in the “Sample Group”.
Click on the tile to see drill-down chart (Average rating by product name).
Note: A complete implementation guide on Smart Business Service is also available at SAP-Press.
Hi. Great blog.
I stuck with selecting of data source - source system. It is empty. However it was created in destinations after SSB became enabled . Connection is ok.
Do you have any thoughts on that ?
You need to manually type the Source System name (BusinessSystem00). In next article, I will explain how to configure BusinessSystem destiantions so that it will come in value help popup.
Some bugs are there. Today, with no changes I am able to see BusinessSystem00 in list of systems !!!
Thank you for this excellent blog. Making the KPI tile working with the demo service went like a charm.
However, I got 2 questions:
Best regards and many thanks in advance
Please find the answers inline below.
Answer: Firstly, you have to configure BusinessSystems. Go to SCP Cockpit –> Services –> Smart Business service –> Configure Business System and click on new destination button.
Now in the Destination configuration section, fill in all the mandatory fields like Name, URL, Authentication, etc. Value for Name field can be from BusinessSystem00 to BusinessSystem10.
For doing so, go to SCP Cockpit –> Services –> Smart Business Service –> Configure Services, now choose Configure Business Systems Tile.
Here, select your business system from the valueHelp and choose your Service Discovery Type from the link available below. Now enter the relative URL of your service and save.
Now in KPI / Evaluation app, you will be able to choose the BusinessSystem from the valueHelp and see the odata service url configured for it.
2. What exact annotations does the OData service have to provide to be accepted by the KPI tile?
Answer: Could you please check whether you are able to create KPI / Evaluation for your service?
There is an error in opening the "Configure KPI Tiles" - "Could not open app. Please try again later."
Where can I submit this bug?
Please try adding TENANT_ADMIN role for your user in cockpit and try.
I get the same error message even if I have the TENANT_ADMIN role assigned.
Can you help?
Sorry, we missed this comment in the blog. I hope the issue you were facing was resolved. Right?
I followed the steps that given above, i created KPI, configured evaluation and drill down. And I was able to save and activate successfully.
But the problem is, I am unable to see Sample Group in the Fiori Launchpad HomePage. Do you know why this happens?
Please check if you have maintained User > Role > Group in HCP cockpit.
If the issue still persists, please contact us on the below mail IDs, to help you resolving the isue
I cannot move forward from the ‘configure KPI tiles’ step. The reason is that I do not see any catalogs in the select catalogs list. Neither can I select any groups. Can you suggest what could be the issue?
Kindly check the below two things:
1. Check if you have the TENANT_ADMIN role assigned
2. Check in the destination -> flpuis -> the Authentication is AppToAppSSO
Thank you for your explanation.
It became a real breakthrough for me in the KPI Tile topic.
And as always several new questions appeared:
1. In ssbservice we can even see 4 entries:
However only two of them appear in the popup list for Entity Set.
2. An other question how to adapt northwind odata service, I have not managed to configure the service for a KPI Tile, the same cause – no Entity Set appears.
We show only those entitiy sets which are aggregatables (which has sap annotations sap:semantics="aggregate"). In the mentioned example, i believe only 2 entity sets have this annotations.
On Northwind odata service, this is not supported as there are 2 containers. SAP UI5 supports only those odata services which has single container.
Thank you Lucky,
It is clear now.
Unfortunately we can create only simple, without "aggregate" attribute, OData services in SAP ByDesign.
What else ways are there to create such a kind of OData service?
If the service support aggregatation, then you can use OData Adapter app in Smart Business to add the required annotations.
Using this app, you can mark entity set aggregatable & also mark Measure & Dimensions. However, the app only helps to add these required annotations. Your service need to make sure that entity is indeed aggregatable.
I have not found an app having name "OData Adapter". Everything I have in my Smart Business Group is :
As far as I can suppose it is the app I marked by the red circle. Is it correct?
Yes that's the one. Configure odata metadata app from smartbusiness is to provide analytical annotation for your odatasercice. But you must make sure that aggregation is supported by your odataservice.
Thanks a lot.
It seems to be clear for me now.
Probably custom OData services in ByD do not have aggregation capability.
How to do this not in hana cloud?
Kindly refer to the following blog:
How to Subscribe to SAP Smart Business Service
Hope this answered your question.
Thanks for the blog Raja Prasad, I do not see the option to choose catalogs or add my tile to any catalog.
I just saw your reply. For the Smart Business for Suite on HANA, you should not see these options, but for the other Smart Business products, you should see them.
Thank You John.
Is there are any similar functionality of this available in the SAP Business Objects Fiori Based LaunchPad? We have a specific need to enable users to create their own KPI tiles in the BI LaunchPad.
I'm unable to see any Catalogs or groups in Configure KPI Tiles step. Can anybody help me out with this?