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 đ đ
User case:
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.
Create KPI
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â.
Create 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â
Configure Tile
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â.
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 ?
Hi Pavlo,
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.
Regards,
Raja
Some bugs are there. Today, with no changes I am able to see BusinessSystem00 in list of systems !!!
Hello Raja,
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
Frank
Â
Â
Hello Frank,
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?
Â
Regards,
Raghavi
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.
Hello,
I get the same error message even if I have the TENANT_ADMIN role assigned.
Can you help?
Hi Fabien,
Sorry, we missed this comment in the blog. I hope the issue you were facing was resolved. Right?
Regards,
Lucky
Hi Raja,
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?
Hello Shravanthi,
Please check if you have maintained User > Role > Group in HCP cockpit.
Regards, Imtiyaz
Hello Shravanthi,
If the issue still persists, please contact us on the below mail IDs, to help you resolving the isue
s.imtiyaz.shariff@sap.com
mythili.r@sap.com
Regards, Imtiyaz
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?
Hi Manikandan,
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
Regards,
Ruchita.
Hello Raja,
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.
Thank you
Aleksei
Â
Hi Aleksei,
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.
Regards,
Lucky
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?
Thank you,
Aleksei
Hi Aleksei,
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.
Regards,
Lucky
Hello Lucky,
I have not found an app having name "OData Adapter". Everything I have in my Smart Business Group is :
Many thanks.
Best regards,
Aleksei
Hi Akeksei,
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.
Regards,
Ananya
Hello Ananya,
Thanks a lot.
It seems to be clear for me now.
Probably custom OData services in ByD do not have aggregation capability.
Best regards,
Aleksei
How to do this not in hana cloud?
Hello,
Â
Kindly refer to the following blog:
Â
How to Subscribe to SAP Smart Business Service
Â
Hope this answered your question.
Â
Regards,
Raghavi
Â
Thanks for the blog Raja Prasad, I do not see the option to choose catalogs or add my tile to any catalog.
Thank You,
Kabir
Hi Kabir,
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.
hi all,
I'm unable to see any Catalogs or groups in Configure KPI Tiles step. Can anybody help me out with this?