In continuation to last blog “Key Takeaways on CDS Views : SAP S/4HANA Cloud“ ; in this we will cover Embedded Analytics in SAP S/4HANA Cloud . Using CDS views, we can build dashboards in just 5 mins, that too without any coding with simply drag and drop!! We will also uncover additional features available in Cloud as compared to On Premise version (1909 FPS00).
Now Business users can create apps on the fly using Reporting apps available in SAP S/4HANA Cloud. Let’s quickly go through options available in SAP S/4HANA Cloud and Fiori apps/options that you should be aware of :
In SAP S/4HANA Cloud; you have Create Application option but in On-Premise version this option is not there from “View Browser” app.
In SAP S/4HANA Cloud, with this end users can create reports by simply using drag and drop functionality. From “View Browser” app you can create application over released analytical queries with the ‘Query’ category type. Users can also analyze their data easily via query designer. There are 2 flavors of the same as shown below
When you click on Create application -> Multi-Dimensional Report; fill in Title and Subtitle.
Once you click on “Ok”; an app id and quick link are generated and available in application ID column. You can click on the application id and assign it to Catalog using “Custom Catalog Extension” app for it to be visible on your FLP.
Once the catalog is assigned; you will see the Tile created in the assigned catalog.On clicking tile you will see the report like below.
- You can drag and drop dimensions into columns/rows to display the graph.
- You can also download the data from here
- Multi-Dimensional Report using Web Dynpro Template :Both function the same way except that the latter creates applications that support users with special needs. Some of the details or the displays pertaining to the applications may be available to users with screen readers and users of keyboard-only navigation.
Analytical Query :
- In both versions On-Premise as well as Cloud , you can create Analytical Query from Fiori app “View Browser” as well over views where Data Category = Cube/Dimension and Status = Released .
- Or you can create using Fiori app ” Custom Analytical Query“
- Or you can use any of standard available analytical queries
- This displays the report in Design Studio
The Query Browser app displays all the authorized published queries that are created in Custom Analytical Queries app and SAP authorized released queries. You can select any of the query and click on “Open for Analysis“. That will open the Query for analysis in Design Studio .
Overview Pages :
- From end user perspective there are pre-delivered Overview Pages which user can use to see the dashboards.You can find all the OVP’s available in Fiori Library by filtering on UI Technology
- SAP Fiori Overview Pages are also extremely flexible and personalizable.
- You can rearrange cards simply by drag and drop
- You can hide cards using Manage cards option from user menu . Click on manage cards will show all the cards for this OVP ; you can hide any unwanted card from here by deselecting radio button .
Manage KPI and Reports
In SAP S/4HANA Cloud; you have “Stories” in addition to KPIs and Reports in “Manage KPI and Reports” fiori app but in On-Premise version this option is not there yet. In SAP S/4HANA Cloud SAC is embedded with 1911 release; for more details refer to very good blog by Rolf here.
Also you don’t have the “Data Analyzer” option yet in S/4HANA On Premise version .
With Cloud 2005 SAP is further bringing enhanced navigation with embedded SAC related dashboards/reports. For details check here.
With KPI Modeler the Super-users can define and create Fiori tiles which will contain the Key performance indicators, crucially important to the organization. Single platform for creating all analytical applications using KPIs, reports, and stories.
You can use the Standard KPIs or you can create your own .The app has KPIs , Reports and Stories out of the box as well .
- Generic Drilldown: To create drilldown based on KPI ; you can create Report of generic drill down that makes use of custom/standard KPIs.
- ALP is an SAP Fiori element which uses business key performance indicators to create analytical dashboards with KPIs, charts, tables, and visual filters. ALP is driven by SAP UI annotations. You can create report having dashboards with just few clicks .
- Data Analyzer, a ready-to-run service for analytical queries, is integrated into SAP S/4HANA to provide an ad hoc query analysis experience to the end user. With Data Analyzer, you can visualize and report on analytical queries in SAP Analytics Cloud without model creation.
- How to use Data Analyzer option is very well explained in blog post “Embedded Analytics: SAP Analytics Cloud in SAP S/4HANA Cloud – How to create Data Analyzer Report“
- You can
- Analyze analytical queries on the fly
- Navigate, analyze, and filter data
- You can assign tile format while assigning application to the data analyzer . Based on which catalog you assign the application to ; you can see the tile under the same.
- Stories: Stories are raw data that transforms into powerful visualizations to help you drive business performance and make data-driven decisions about your business. You can use Out of box stories given by SAP / You can create your own stories ; very well explained by Avinash Kumar in his blog “Embedded Analytics: SAP Analytics Cloud in SAP S/4HANA Cloud – How to create your own Dashboard or Story“.You can configure a story with a wide selection of charts and tables that best display the selected measure. Using the designer panel, you can refine the objects, change the chart type and add new objects.
Summary : In this Blog we covered some of Fiori apps that user can leverage to create dashboards in S/4HANA Cloud … No coding and beautiful reports and dashboards are ready for use using these apps :)..