SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 5)
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 –> http://scn.sap.com/community/s4hana/blog/2016/03/10/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-13
Part2 of the Blog can be found here –> http://scn.sap.com/community/s4hana/blog/2016/03/11/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-2
Part3 of the Blog can be found here –> http://scn.sap.com/community/s4hana/blog/2016/03/20/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-3
Part4 of the Blog can be found here –> http://scn.sap.com/community/s4hana/blog/2016/07/15/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-4
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 written here –> https://blogs.sap.com/2017/11/23/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-7/
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.
9) Through this blog, we will try to see how an Analysis Path Framework (APF) is created on top of CDS Views.
For those who are new to APF and related configurations, I would request you to go through the following SAP Help Documents.
Earlier also, we had this APF concept available with HANA view/SOH data source. These days, we see this option been reflected quite extensively in most of the S/4HANA Embedded Analytics SAP official Slides.
The configuration steps until “Fiori Smart Business Add Tile” option remains the same as what we discussed in the Part 4 of this series.
To avoid the repetition of steps, I am ignoring the following steps in this current blog.
a) Creation of CDS in ABAP Perspective of HANA studio with some important annotation like @Odata.publish : True
b) Manual addition of the Service which was created automatically during the CDS View activation process
c) “Create KPI Tile” step in Fiori Launchpad under “KPI Design” Group.
d) Providing the important information like CDS View, Odata service and so on.
e) “Activate and Add Evaluation” step
We will see in depth explanation from “Activate and Configure Tile” Step:
Before proceeding with the “Add Tile Screen configuration”, you need to do some steps in APF Configuration Modeler tile.
Note: You will see this above tile, only if you have done the Proper APF configuration in your side (as mentioned in the links mentioned in the beginning of this blog).
With this Tile, you can create an Application, Configuration, Category, Filter and Navigational Target (Optional)
When you click on the tile “APF Configuration Modeler”, it will ask you to create a new Application.
Here I have created an application named “APF CDS SLcM”
Inside the Application, we need to create a Configuration.
Note: Configuration ID would be proposed by the system.
Go to the corresponding URL and please note the Application and Configuration name that you get in this screen.
Note that here Application number is 14637198956061520825489804911392 and Configuration number is 14637207315233629446844676851368.We would be using it during the “ADD Tile” configuration step later.
You can add different configuration objects(shown below) with Add option.
Now we can add New Category.
Now we can add one or many Steps within a category.
Here, I would be adding 2 steps:
1) Academic Year Name
Please note that ZCombined_reg_Module_Data is my CDS View name and ZCombined_reg_Module_Data_CDS is the autogenrated service.
In addition, I would like to highlight here that the underlying CDS View has been created after copying the standard CDS views, which SAP has delivered along with SAP Student Life Cycle Management module.
Now, we need to add a representation within the Step. Here I have used “Column Chart”.
Please note that SAP has provided around 14 Types of charts, for you to play around in case of APF requirements. Please find the list below:
2) Academic Session
Now, we need to add a representation within the Step. Here I have used “ Line Chart”.
For demonstration purpose, I have added 2 filters as well:
Filter 1: Academic Session
Filter 2: Academic Year
Now we will go back to the Fiori Lauchpad Smart Business Framework to continue with “ADD TILE” step.
The Title, Subtitle details can be provided according to your customer requirement.
We need to provide a catalog name here (In my case, I have kept ZAPF)
We have 2 options available under Select Drill-Down. Here we have to select “Others”
Keep Semantic Object as “FioriApplication”
Action as “executeAPFConfigurationS4HANA”
Application parameter Name as “sap-apf-configuration-id”
Application value as 14637198956061520825489804911392.14637207315233629446844676851368
We got the above 2 values (APPLICATION.CONFIGURTAION) from Configuration Step.
Now we can save the tile configuration.
I will not be doing any Drill Down Configuration in this case.
The Following 3 steps have been shown in detail in the Part 4 of this blog series and hence the same will not be covered here.
1) Add the Catalog to a role.
2) Add the role to a user.
3) In Fiori Launchpad, find the tile from the catalog and add it under a group name (in this case, I have added it under the group “Analysis Path Framework”)
After doing the above 3 steps, you will see the following:
Click on the tile “HANA Embedded Analytics”. You will get the following screen
Click on the “ADD Analysis Step”
You will see the Defined Category. Click on the category.
It will take you to the Defined Steps.
Click on step 1: Academic Year Name to show the representation within that step.
Click on the Column chart to see the actual chart.
In case if you want to add some filters, select the filter values and the chart will change accordingly.
10) View Browser:
Earlier, lot of our customers were facing issues with the Query Browser, where we could only see the Consumption Views.
Thanks to SAP for introducing the View Browser App.
With this we can now see all the available “Basic”, “Composite” and “Consumption” views.
Thanks for going through the Document. Do let me know your Reviews and Suggestions.