Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Raja_Gupta
Product and Topic Expert
Product and Topic Expert
34,733
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 :cool: :cool:

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.
30 Comments
pavlo_denysyuk
Participant
0 Kudos

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 ?

Raja_Gupta
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

pavlo_denysyuk
Participant
0 Kudos

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

Former Member
0 Kudos

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 Kudos

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

0 Kudos
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 Kudos
Hello Shravanthi,

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

Regards, Imtiyaz
0 Kudos
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
Former Member
0 Kudos
Hello,
I get the same error message even if I have the TENANT_ADMIN role assigned.
Can you help?
manikandan_tr
Explorer
0 Kudos
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?

 
Former Member
0 Kudos
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.
architectSAP
SAP Mentor
SAP Mentor
0 Kudos

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

 

 

abelousov
Active Participant
0 Kudos

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 Kudos
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 Kudos
Hi Fabien,

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

Regards,

Lucky
abelousov
Active Participant
0 Kudos
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 Kudos
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
abelousov
Active Participant
0 Kudos
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 Kudos
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
abelousov
Active Participant
0 Kudos
Hello ananya.mallik,

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

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

mrwong05
Participant
0 Kudos
How to do this not in hana cloud?
0 Kudos

Hello,

 

Kindly refer to the following blog:

 

How to Subscribe to SAP Smart Business Service

 

Hope this answered your question.

 

Regards,

Raghavi

 

developerone
Contributor
0 Kudos
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
jtaylor
Active Participant
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.
developerone
Contributor
0 Kudos
Thank You John.
0 Kudos
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.
0 Kudos
hi all,

I'm unable to see any Catalogs or groups in Configure KPI Tiles step. Can anybody help me out with this?
mallikarjuna_b05
Explorer
0 Kudos
Hi All,

 

How do i create the dashboard type tile (like column chart ) , i have tried witg trend kpi tile but this will not resolving my use case.

We are into Suite On HANA landscape , do we have an option to create a dashboard KPI which will shows the overview of operations of the wherehouse.

Please share me some information on this.

 

Regards,

Mallikarjuna B.
mallikarjuna_b05
Explorer
0 Kudos

Hi Raj Prasad,

In my landscape ( Business suite on HANA ) , we can not see Catalog and group input fields while configuring a KPI tile. .

After custom tile creation in KPI workspace , how we can see same KPI tile under catalogs or how do we map custom KPI tile to the standard/remote catalogs because we can not see them in my landscape , could you please advice me on this .

I really appreciate your percious time.

 

Thanks and Regards,

Malli.