Skip to Content
Author's profile photo Raja Prasad Gupta

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.

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.

/wp-content/uploads/2016/06/19_983887.png

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.

/wp-content/uploads/2016/06/1_983972.png

2. Enter KPI Title as “Average Product Rating”.

2.PNG

3. Go down and enter Source System as “BusinessSystem00”.

    Enter OData Service as “/ssb/services/democontent/odata/smartbusiness.svc”.

3.PNG

 

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

/wp-content/uploads/2016/06/4_983975.png

 

5. Finally click on “Activate and Add Evaluation”.

Create Evaluation

1. Enter title as For Alpine System.

5.PNG

2. Go down and click on “Optional Filters”.

6.PNG

3. Select “Supplier Company” and click on OK.

7.PNG

4. Click on “Values” and select Alpine System.

8.PNG

 5. Enter following Thresholds and finally click on “Activate and Configure Tiles”

9.PNG

Configure Tile

1. Click on “Add Tile” button.

10.PNG

2. Select Catalogs and Groups.

/wp-content/uploads/2016/06/11_983985.png

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.

/wp-content/uploads/2016/06/12_983986.png

2. Select “Product name” as Dimension.

/wp-content/uploads/2016/06/13_983990.png

3. Select “Rating for Item” as Measure.

14.PNG

4. Enter “View Title” and click on “Save”.

/wp-content/uploads/2016/06/15_983992.png

5. Click on “Save Configuration”.

16.PNG

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

17.PNG

Click on the tile to see drill-down chart (Average rating by product name).

18.PNG

 

Note: A complete implementation guide on Smart Business Service is also available at SAP-Press.

Assigned Tags

      28 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Pavlo Denysyuk
      Pavlo Denysyuk

      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 ?

      Author's profile photo Raja Prasad Gupta
      Raja Prasad Gupta
      Blog Post Author

      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

      Author's profile photo Pavlo Denysyuk
      Pavlo Denysyuk

      Some bugs are there. Today, with no changes I am able to see BusinessSystem00 in list of systems !!!

      Author's profile photo Frank Schuler
      Frank Schuler

      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:

      1. How do I add a business system so that I can chose it from the drop down and discover its services?
      2. What exact annotations does the OData service have to provide to be accepted by the KPI tile? I got a service based on a HANA Calculation View with OData4SAP annotations enabled and one dimension and one measure, but that is not accepted due to OData4SAP annotations missing. This is how its metadata looks like:
      <edmx:Edmx xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" xmlns:sap="http://www.sap.com/Protocols/SAPData" Version="1.0">
      <edmx:DataServices xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="2.0">
      <Schema xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://schemas.microsoft.com/ado/2008/09/edm" Namespace="c4pa.service">
      <EntityType Name="c4paType" sap:semantics="aggregate">
      <Key>
      <PropertyRef Name="G_ID"/>
      </Key>
      <Property Name="G_ID" Type="Edm.String" Nullable="false" MaxLength="2147483647" sap:filterable="false"/>
      <Property Name="G_CREATED" Type="Edm.DateTime" sap:label="G_CREATED" sap:aggregation-role="dimension"/>
      <Property Name="C_TEMPERATURE" Type="Edm.Double" sap:filterable="false" sap:label="C_TEMPERATURE" sap:aggregation-role="measure"/>
      </EntityType>
      <EntityContainer Name="service" m:IsDefaultEntityContainer="true">
      <EntitySet Name="c4pa" EntityType="c4pa.service.c4paType"/>
      </EntityContainer>
      </Schema>
      </edmx:DataServices>
      </edmx:Edmx>

      Best regards and many thanks in advance

      Frank

       

       

      Author's profile photo Raghavi H S
      Raghavi H S

      Hello Frank,

      Please find the answers inline below.

      1. How do I add a business system so that I can chose it from the drop down and discover its services?

      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

      Author's profile photo Former Member
      Former Member

      There is an error in opening the "Configure KPI Tiles" - "Could not open app. Please try again later."

      Where can I submit this bug?

      Author's profile photo Ananya Mallik
      Ananya Mallik

      Please try adding TENANT_ADMIN role for your user in cockpit and try.

      Author's profile photo Former Member
      Former Member

      Hello,
      I get the same error message even if I have the TENANT_ADMIN role assigned.
      Can you help?

      Author's profile photo Lucky Jindal
      Lucky Jindal

      Hi Fabien,

      Sorry, we missed this comment in the blog. I hope the issue you were facing was resolved. Right?

      Regards,

      Lucky

      Author's profile photo Shravanthi B J
      Shravanthi B J

      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?

      Author's profile photo Shaik Imtiyaz Shariff
      Shaik Imtiyaz Shariff

      Hello Shravanthi,

      Please check if you have maintained User > Role > Group in HCP cockpit.

      Regards, Imtiyaz

      Author's profile photo Shaik Imtiyaz Shariff
      Shaik Imtiyaz Shariff

      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

      Author's profile photo Manikandan T R
      Manikandan T R

      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?

       

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Aleksei BELOUSOV
      Aleksei BELOUSOV

      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:

      <service xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom" xml:base="https://ssbserviceu2aa57004-i857813trial.hanatrial.ondemand.com:443/ssbservice/ssb/services/democontent/odata/smartbusiness.svc/">
      <workspace>
      <atom:title>Default</atom:title>
      <collection href="Sales">
      <atom:title>Sales</atom:title>
      </collection>
      <collection href="Supplier">
      <atom:title>Supplier</atom:title>
      </collection>
      <collection href="Product">
      <atom:title>Product</atom:title>
      </collection>
      <collection href="Purchase">
      <atom:title>Purchase</atom:title>
      </collection>
      </workspace>
      </service>

      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

       

      Author's profile photo Lucky Jindal
      Lucky Jindal

      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

      Author's profile photo Aleksei BELOUSOV
      Aleksei BELOUSOV

      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

      Author's profile photo Lucky Jindal
      Lucky Jindal

      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

      Author's profile photo Aleksei BELOUSOV
      Aleksei BELOUSOV

      Hello Lucky,

      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?

      Many thanks.

      Best regards,

      Aleksei

       

      Author's profile photo Ananya Mallik
      Ananya Mallik

      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

      Author's profile photo Aleksei BELOUSOV
      Aleksei BELOUSOV

      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

      Author's profile photo Matthew Wong
      Matthew Wong

      How to do this not in hana cloud?

      Author's profile photo Raghavi H S
      Raghavi H S

      Hello,

       

      Kindly refer to the following blog:

       

      How to Subscribe to SAP Smart Business Service

       

      Hope this answered your question.

       

      Regards,

      Raghavi

       

      Author's profile photo Sai Kowluri
      Sai Kowluri

      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

      Author's profile photo John Taylor
      John Taylor

      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.

      Author's profile photo Sai Kowluri
      Sai Kowluri

      Thank You John.

      Author's profile photo Gopi Kengatharan
      Gopi Kengatharan

      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.

      Author's profile photo Santoshi Alluri
      Santoshi Alluri

      hi all,

      I'm unable to see any Catalogs or groups in Configure KPI Tiles step. Can anybody help me out with this?