Skip to Content

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

Note1: In case you do not see “Sample Group” in Fiori Launchpad, this means you do not have role assigned to it. Refer to Fiori Help Document to know more about this.

Note2: In case you face any issue with Smart Business Service, you can create an Incident on SAP Support PortalInformation published on SAP site with the  components: CA-GTF-SB-HCP. You may also contact Smart Business team at smartbusiness@sap.com

To know more about Smart Business Service, refer to the article Smart Business Service

To report this post you need to login first.

23 Comments

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

  1. 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 ?

    (0) 
    1. Raja Prasad Gupta 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

      (0) 
      1. 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

         

         

        (0) 
        1. 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

          (1) 
  2. Andre Friese

    There is an error in opening the “Configure KPI Tiles” – “Could not open app. Please try again later.”

    Where can I submit this bug?

    (0) 
  3. 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?

    (0) 
  4. 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?

     

    (0) 
    1. Ruchita D Kasliwal

      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.

      (0) 
  5. 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

     

    (0) 
    1. 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

      (0) 
      1. 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

        (0) 
        1. 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

          (0) 
          1. 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

             

            (0) 
            1. 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

              (0) 

Leave a Reply