SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 7)
S/4HANA is steadily gaining shape in the market and so is the S/4HANA Embedded Analytics.
Through these series of blogs, am trying to give you a glimpse of various tools that are currently available for the customers.
Part 1 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
Part 2 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
Part 3 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
Part 4 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
Part 5 of the Blog can be found here –> https://blogs.sap.com/2016/07/19/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-5
Part 6 of the Blog can be found here –> https://blogs.sap.com/2017/06/30/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-6/
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 part, am going to take you through a new tool set that was introduced in SAP S/4HANA 1709.
Analytical List Reports:
By now, many of you would have seen or utilized the following tiles to create a SMART Business App.
In 1709, SAP has introduced the following 5 tiles which basically comes under “REPORT DESIGN”
You can use this “Report Modeler Framework” to create an Analytical List Report without any sort of coding.
Let’s try to see how we can use the above app’s to create some meaningful reports.
1) Click on “Create Reports” App.
Same as in Smart Business Framework, provide the basic details like CDS Views, odata Service and Entity Set.
I have filled in the required details. Please not here am using a Standard Consumption type CDS view related to Days sales Outstanding.
2) Activate and Add Evaluation:
Give Customizing Request. This ensures that our developments are properly tagged to a Request.
This will open up the App named “Create Report Evaluation” . Provide the necessary Evaluation details like Evaluation name and so on.
The Input Parameter related details are filled and click activate.
3) Now use the App “Configure Report Drill Down”
Click Configure. Provide the required Dimensions and measures for analysis.
There are options for Single and Dual Axis.
Dual Axis would provide Stacking facility.
There are different Chart Types Available.
Provide a meaningful name and Click OK
Provide a meaningful name and Click OK
The “Analytical List Page” broadly has 3 different panes like Filter, Charts and Tables.
So I believe its mandatory to have 2 separate views to save our configuration at this stage.
Also the configuration chart type would be “Table” ; By Default.
Provide a meaning full name. Now Both Configurations are saved.
4) Click on “Publish Report”(Create Tile for Report) APP
You can see the report and evaluation names created in steps 1 and 2 in the Tile and Sub tile respectively.
Tag your developments to your related “Catalog”.
Also its mandatory to provide the Semantic object and Action, here in this screen.
Always, you will have the flexibility to see your entire developments in the “Report Workspace” App.
Publish Report will show the following screen:
5) Now Create a meaningful Role in PFCG and add your catalog to the Role.
6) Add the role to the user. Here am using a dummy user.
7) Open up your Fiori Launchpad (Clean up the cookies and history as a best practice) and provide the user name and password (Same username where you had added the role earlier)
Use App Finder to look for your catalog.
Add it to the required folder. Am adding to Home page.
8) Now log into the Home Page and See your Analytical List Report ready for the user analysis.
Please note that this feature is relatively new and has come up with 1709 release.
My intention with this blog was to take you through the steps and help you understand how easy is to configure a Report with the help of this framework.
If I manage to find more information on this topic like additional features or existing limitations, I will certainly add the same to this blog.
Hope this blog was useful for you. Do let me know your Reviews and Suggestions.
I have created a ALP APP using Report Modeler Framework, but I think important thing is missing here. It has 3 components Filters, Chart and Table.
Now Filter as you have also shown comes as the normal filters, but the examples which SAP has given has Visual filters (filters with charts).
I think this option is not there as Out of box tool instead it may be there in WEB IDE.
Do you have knowledge on that ?
Thanks for continuing this series. I couldn't dfind Report Modeler Framwwork in the fiori App library . Couls you pls suggest the correct name of this App