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.
😎 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:
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.
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.
Now we need to log into the Fiori Launchpad to configure the Smart Business Tiles.
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.
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.
Now we need to proceed by creating an Evaluation. For that, click on the following option.
In the next screen, you need to provide Evaluation name.
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.
Now we need to add a Tile. For that, we need to use the following button.
That will take you to the following screen.
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.
If you would like add some Drill Downs, click on the following:
You will reach the following screen, from where you can configure the drill downs.
Click on 'CONFIGURE' button for the same.
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:
Drill Down 2:
Click save configuration button after completion.
If you want to navigate through all the configurations that we have created till now, you can proceed with the following tile.
Now we need to add the catalog (created earlier) to a role.
For that access PFCG Tcode in the front end server.
- 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.
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.
Search for your tile and add it to the Home page/or a group name of the user.
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.
Thanks for going through the Document. Do let me know your Reviews and Suggestions.
BR
Prabhith