Skip to Content
Author's profile photo Prabhith Prabhakaran

SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 4)

Hi All,

S/4HANA is steadily gaining shape in the market and so is the S/4HANA Embedded Analytics.

 

Part1 of the Blog can be found here –>  SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 1)

Part2 of the Blog can be found here –>  SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 2)

Part3 of the Blog can be found here –>  SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 3)

Part5 of the Blog can be found here   –> SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 5)

Part6 of the Blog can be found here –> https://blogs.sap.com/2017/06/30/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-6/

Part7 of the Blog can be found here –> https://blogs.sap.com/2017/11/23/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-7/

 

Introduction:

What is S/4HANA Embedded Analytics?

          It is the collection of all Analytical Features integrated in the SAP S/4HANA Suite that enables, Business users or end users to perform real time analytics or operational reporting on the live transactional data. It comes with a set of predefined and prepackaged representations of operational data. These representations called VDM (Virtual Data Models) allows business users to derive good insights into the data.

8) Through this blog, we will try to see how CDS views are consumed in Fiori Smart Business Framework.

 

To begin with, we need to have a CDS view (Creation of CDS View in ABAP perspective is out of scope of this blog) with the Annotation @odata.publish=true.

When a CDS view is activated with the above-mentioned annotation, an service is automatically created in the gateway system with naming convention <CDS_VIEW_NAME>_CDS.

 

Let us have a simple CDS View with the following annotations:

/wp-content/uploads/2016/07/1_995929.png

Also, note that we have an annotation @OData.publish: true

 

After activation of the CDS, you can see the following message in the line in which the above annotation is added.

/wp-content/uploads/2016/07/2_996002.png

 

Note that my CDS view name is ZF_HADOOPCDS and hence the automatically created service name would be ZF_HADOOPCDS_CDS. Now let us go into the Gateway system and add the automatically created service.Enter the transaction /n/IWFND/MAINT_SERVICE and add the service. (Using Get Services option against your backend system).Once the service is added successfully, you will see the service in the service catalog.

/wp-content/uploads/2016/07/3_995936.png

Now we need to log into the Fiori Launchpad to configure the Smart Business Tiles.

/wp-content/uploads/2016/07/4_995937.png

 

The above-mentioned tiles (under KPI Design group) are called the Smart Business Tiles and the entire framework is called Smart Business Frame work.

 

Click on “Create KPI” tile to add the KPI name and CDS related details.

/wp-content/uploads/2016/07/5_995942.png

/wp-content/uploads/2016/07/6_995938.png

 

Note that, as soon as you give your CDS View name, the related ODATA service, Entity Set and Value Measure  (I have a measure in CDS named ‘claim amount’ with local annotation @DefaultAggregation: #SUM) will automatically be available in the F4 List.

 

 

IMPORTANT POINT TO REMEMBER:

In case, if you were modelling a Smart Business Tile using HANA View in a Suite on HANA (SOH) Scenario, most of the configuration steps mentioned here would be the same except the Data source part. In such a scenario, your source would be HANA view and the Odata service needs to manually created in the HANA Development Perspective using some options like XSODATA.

SOH.PNG

 

 

 

Now we need to proceed by creating an Evaluation. For that, click on the following option.

/wp-content/uploads/2016/07/7_995943.png

 

In the next screen, you need to provide Evaluation name.

/wp-content/uploads/2016/07/8_995948.png

And if interested, show some thresholds (to show some exceptions).

Here I am providing values as below. This will later help in showing different colours in the Numeric tile according to Thresholds.

 

/wp-content/uploads/2016/07/9_995949.png

 

Now we need to add a Tile. For that, we need to use the following button.

/wp-content/uploads/2016/07/10_995954.png

That will take you to the following screen.

/wp-content/uploads/2016/07/11_995950.png

 

In this scenario, we are using a Numeric Tile.Note that you can change the Tile Format, Tile name and Tile Sub Title name according to your requirement. You have different tile formats available.(like Shown Below)

 

Numeric Tile

Comparison Tile

Trend Tile

Actual Vs Target Tile

Comparison Tile Multiple Measures

Blank Tile

Dual Tile

 

 

Please look into Help.Sap.com for details related to each tile type.

 

In the Add Tile screen, we need to add our tile to a specific Catalog which will later be added to a role and the role will later be added to the Fiori Launchpad user.

 

I have added the tile to a Catalog named ZCatalog_Hadoop.

/wp-content/uploads/2016/07/13_995956.png

 

If you would like add some Drill Downs, click on the following:

/wp-content/uploads/2016/07/14_995957.png

You will reach the following screen, from where you can configure the drill downs.

Click on ‘CONFIGURE’ button for the same.

/wp-content/uploads/2016/07/15_995958.png

 

Select the Dimensions and Measures that you would need in the Drill down.

Here I would be adding 2 drill downs and 2 view names would be provided accordingly.

 

Drill Down 1:

/wp-content/uploads/2016/07/16_995959.png

/wp-content/uploads/2016/07/17_995963.png

 

/wp-content/uploads/2016/07/18_995964.png

Drill Down 2:

  /wp-content/uploads/2016/07/20_995970.png

    /wp-content/uploads/2016/07/21_995972.png 

/wp-content/uploads/2016/07/22_995974.png

 

  Click save configuration button after completion.

 

/wp-content/uploads/2016/07/24_995978.png

If you want to navigate through all the configurations that we have created till now, you can proceed with the following tile.

 

/wp-content/uploads/2016/07/25_995979.png

 

/wp-content/uploads/2016/07/26_995980.png

 

Now we need to add the catalog (created earlier) to a role.

For that access PFCG Tcode in the front end server.

/wp-content/uploads/2016/07/27_995984.png

  • Please note that you need to click on Menu tab and Fiori Launchpad Catalog option

 

Now we need to add the above role to a Fiori launchpad user who would access this newly created Smart Business tile.

 

/wp-content/uploads/2016/07/28_995986.png

In my case, the user name is S4DEMO

 

Now log off from the Fiori Launchpad page, do a cache delete and login with the S4DEMO credentials

You have to search for your catalog using the “Open App Finder” option.

 

/wp-content/uploads/2016/07/29_995993.png

Search for your tile and add it to the Home page/or a group name of the user.

/wp-content/uploads/2016/07/32_995994.png

NOTE: Green Colour has come up due to the Thresholds that was given earlier.

Click on the Tile and you can see the drill downs.

/wp-content/uploads/2016/07/33_996000.png

 

/wp-content/uploads/2016/07/34_996001.png

 

Thanks for going through the Document. Do let me know your Reviews and Suggestions.

 

BR

Prabhith

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

      You have used a semantic object called claim_amount while configuring the tile, did you create this semantic object anywhere in the KPI designer??

      Author's profile photo Prabhith Prabhakaran
      Prabhith Prabhakaran
      Blog Post Author

      Hello imran khan

      No, the particular semantic object was never created from my side in any stage of the configuration process.

      BR

      Prabhith

      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

      Do you have any detailed PPT's or documents on below topics?

      S/4 Delivered analytics content approach, CDS views and Embedded BW content.

      Would request you to please provide if you having any of those as i have to give 90 minutes demo on this. am not able to fine anywhere.

      I know only SAP HANA & BW powered by HANA. but no knowledge on S/4 HANA. Hence am requesting you to help me with detailed PPT's or documents if any.

      Thank you so much in advance..

      Mail id: balagreddy@gmail.com

      Regards,

      Balaji

      Author's profile photo Rama Shankar
      Rama Shankar

      Hi Prabith,

       

      Awesome Blogs!! Thanks.

       

       

      Author's profile photo Smriti Gupta
      Smriti Gupta

      Hello Prabhith,

       

      Excellent series! Many thanks for introducing this strucured blod on Embedded Analytics

       

      Regds

      Smriti

      Author's profile photo Former Member
      Former Member

      Hi Prabith,

      Great document , I am in the process of learning S4 hana myself. It would be great if i get your support on the same. Can you please gimme your mail id atleast. I wiill be reachable on dilipdamodhar@gmail.com