Embedded Analytics in Action…Analytical List Page(ALP) Report in Minutes
Hello Everyone. In my earlier blog Change for Good…Analytics with S/4HANA 1909 we saw that, with 1909, we have a new app called “Manage KPI & Reports” and it will replace the existing KPI and Report designer apps.
In this blog, i will show you how to create similar ALP report with Smart visual filters, KPI Tags etc. using “Manage KPI & Reports” app and with much less effort..sounds exciting?? ..i felt the same :).
Lets do some action…
|Role required to be able to access the app is SAP_BR_ANALYTICS_SPECIALIST|
Once you have added the role , you will see the below App. Click to open It.
On the landing page, you will see KPI & Reports filter at the top left corner. Click on Reports.
Next, Select Create=>Analytical List Page as highlighted below.
Maintain Report Title, Subtitle and other details and click on Activate.
So we have created the report template with basic details. Lets move further. Select the Define link under Data source details section.
Select the CDS view and the associated OData Service and Entity.
For this demo, i selected the standard CDS view “C_OVERDUEPO” for Overdue Purchase Order details and the associated standard OData service.
The chart will be added with one of the measure from the selected CDS view.
Click on settings to select required dimensions and measures as per need. Lets say we want to see the Open PO net value by Purchase Oder number and Purchase Organisation.
The updated chart will be displayed. Note, that the data displayed here is only dummy data. Actual data will be visible on actual app execution.
Now if we want different chart type, click on the graph icon on the right corner to select as per your choice.
And the chart will change with PO numbers and PORG with their respective open Net value.
Scroll down to the Table section and click on settings icon to select the required fields to be displayed in Table under the chart.
And we should see the table with selected fields and dummy data
Activate the report and pass on the Transport request details in the popup.
So, to this point we have Created the report with chart and Table to be displayed with dettails from the selected CDS view and ODATA service. Next, lets create some Smart Visual filters.
Go to the “Input Parameters and filters and click on “Visual Filters” icon
Click on “+” to create one and pass on the Chart Type,measure and dimension details. We could also specify here how we want the data to be sorted.
Moving on, lets add some KPI Tags also. Go to the KPI tags section and click on “+” icon.
All the existing KPIs will be listed and we can select what we want. Here , i searched for KPIs related to Overdue POs.
With this we are done with creation of Visual Filters and KPI tags. Activate the report.
Last step we are left with is the creation of the App Tile. Select the “Application” tab at the top.
Click on Add tile.
Fill in the Details like, App Title, subtitle, Catalog, Semantic tag , action etc and save.
With this we are done with the ALP app creation. Now is the time to test it … Are you ready for it?
|As we have already linked the App tile to the Catalog and catalog should already included in a role ans the same should be assigned to the user.|
Go to the Fiori launchpad , search for the app and add it you the required group. I have added it to my home group as shown below.
Click on the app to run it…and here we have the view of the final app.. Wonderful..isn’t it?
If we select a specific Item on the visual filter , the rest of the data in underlying Chart , Table and KPI tag gets automatically filters. Here i selected PO “4500000003” on the visual filter and you can see the refined data underneath.
Similarly, if I click on the KPI tag (Non filterable), it shows the KPI card as shown below.
With this we have come to an end . Hope this will help you to create wonderful ALP apps and that too with ease.
Keep learning and keep sharing!!