ALP(Analytical List Pages) Reports from Manage KPI & Reports Tool
This blog is basically to give a brief about the new tool available to simplify the design/creation of Analytical list Page Fiori applications (ALP). Usually, for ALP Applications we need to write a lot of annotations in our consumption CDS view, like annotations to create list, annotations to create charts, selection variants, SelectionPresentation variants, PresenationVariants. Some local annotations need to be added on the UI side also. From ABAPes point of view, this entire exercise of understanding annotations and writing them is a bit difficult and something new. They are more accustomed to designing Data models.
This new tool “Manage KPI and Reports” helps to reduce the effort of writing annotations so that more attention can be paid to the Data model.
Let’s start with a short introduction of the Analytical List page Reports, then a brief about the previous approach, and an introduction to a new tool to develop these reports easily.
Analytical List Page is a powerful Fiori Element that provides the ability to create an analytical dashboard with KPIs, charts, tables, and also drill-down navigation to a detail page.
It basically consists of three areas.
Contains the variant management and a section of global KPI tags. Each tag is associated with a detailed chart.
Page Header :
Composed by the filter area which allows users to filter the result set.
Two types of filters are supported, Users can toggle between the two filter modes anytime
- Compact Filters
- Visual Filters (Visual filters are composed of a title and an interactive chart)
Page Content: Consists of a Result set, can be displayed in three different modes.
Chart only view
Table only view
Hybrid view( Both Chart & Table)
Previous Approach: We used to add a lot of annotations in CDS, along with some local annotations that need to be added on the UI side.
For Eg. Annotations required for KPI tags and changes in the Manifest.json file like below. Then this selection presentation variant has to be added in the Manifest.json file against “keyPerformanceIndicators” attribute of the UI application.
Same way lot of Charts need to be created in CDS using @UI.Chart annotations, then mapped presentation variants have to be added in local annotations in WebIde to create visual filters and charts in the page content area.
There is a lot of effort going in to create all these elements, but in a way, it was good to get a basic understanding of how things fit together. Now there is a new tool that simplifies the creation of Analytical List Page reports.
Manage KPI and Reports: A single platform used to create groups, KPIs, reports, and applications that can be launched directly from SAP Fiori launchpad.
Role Required: SAP_BR_ANALYTICS_SPECIALIST
ICF node Details :
|ANALYTICSDTS1||Manage KPIs and Reports||ui.cloudfnd.analyticsdesigntool.s1||/sap/bc/ui5_ui5/ssb/ANALYTICSDTS1|
Now first create a simple CDS (consumption view), without any annotation containing all the fields required in the ALP application. Publish it as an OData service. Aggregation attribute is required to be there solving the similar purpose like Query browser. No need to add an annotation for Charts, Presentation variants, selection variants like before.
Now go inside Manage KPI and Reports application. Switch to Reports Tab, then click Create, select Analytical List page
Give Data Source Details: Referenced CDS need not be having any annotations, like in normal ALP.
Now once the CDS & OData service is mapped, switch to the configuration tab, where you can create KPI tags, Input parameters, charts, tables.
To add KPI tags, first create individual KPI using the same application from the KPI tab.
Now switch back to ALP Report, click on KPI Tags under the Configuration tab. Select created KPI, so now KPI is added to your ALP Report.
Now to add visual Filters to the report, click on the Input Parameters and Filters under the Configuration tab.
Now add a new Visual filter by clicking the + icon.
Supports three chart types :
Provide Dimension and measure by selecting from the dropdown. (* same we used to do by specifying in annotations). That’s it. that too without adding a single annotation for it. You can add multiple visual filters as per your requirement.
Now coming to the Page content area. Select table from Configuration drop-down, then select all fields you want to add as columns.
It’s for displaying data in tabular form instead of aggregated one.
Click on Settings and Select all columns required in the table.
then the table is displayed, no need to add any annotation for it 🙂
We can add a chart also in Page content, select Chart from Configuration dropdown, then select Attribute which can act as Dimension (Assign Role as Category to it), Select measure. And that’s it. No need to add an annotation for it also.
A chart will be visible after that.
Activate, then create Application & Fiori tile from the Application tab for your ALP report.
You have to specify Semantic object, action & other details in the same way as we do while creating Fiori Tile.
So ” Manage KPI and Report” is a standard tool that can be used to Create KPIs, Generic drill down Reports and Analytical List page reports. All the previous KPI tools for creating new KPIs, Evaluations, Associations, Drilldowns, Reports are now obsolete and everything is combined into this new single platform.
Along with KPI-related applications, you can also create ALP reports using this tool. You can create all elements ( KPI tags, Visual Filters, Charts & Tables) of the ALP report using the graphical user interface provided with this tool without having to write a single annotation on CDS or UI.
Please check this tool and provide feedback in case this is helpful.
Below are some references which can be helpful to get more insight into this.
You can also post your queries related to Fiori elements at the below link.