Navigation from OVP card to KPI Drilldown report
Please refer to my first blog:
This blog is extending my first blog. Navigation from OVP cards to the Drilldown application (Which is
developed by using Manage KPIs and reports)
In the Annotation file:
We need to add UI.Identification annotation in the annotation.xml file.
The XML code is like the below:
<!--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--> <!--++++++++++++++++++++++++UI.Identification+++++++++++++++++++++++++++++++++++--> <!--++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--> <Annotation Term="UI.Identification" Qualifier="zpurchasereqtopo"> <Collection> <Record Type="UI.DataFieldForIntentBasedNavigation"> <PropertyValue Property="SemanticObject" String="zidkpidemo"/> <PropertyValue Property="Action" String="analyze"/> <!--<PropertyValue Property="RequiresContext" Bool="true"/>--> <PropertyValue Property="Inline" Bool="true"/> </Record> </Collection> </Annotation>
Need to create a Generic drill-down report with Manage KPIs and reports:
In the Manage KPIs and Reports application, we need to create Group,
After mentioning the Title, we need to click on Save and Activate button it’s going to be created.
Then we need to create the KPI, Once click on the + symbol in the KPIs section, We can find the Define option
Once clicked on the define option we can see the Select Data Source popup, here we need to select the required CDS service
Then we need to select at least one measure in the Value Measure input the activate KPI
Once KPI is activated we can see Create Report option in the right corner header. after clicking on that we can see the Generic Drilldown option you can see that in the below screenshots
Once select Generic Drilldown-> we can see the Create Report page in which we can have the option Configuration, in that we can select Input parameters and Filters and Mini chars, and we can create charts &table
In the Charts and Table section, we have Add View option like below
After clicking on the Add View, we can have a popup like the one below we need to provide View Title and need to click on Add
Once click on the add we can have created the Chart here we can see multiple options
We can select required charts, We can add multiple views
We can select multiple dimensions and measure them.
We need to activate the report as the final step.
After activating the report, we Show-Preview.
From here we created the KPI Drilldown report, next step is we need to add the application catalog as a tile
In the Application section, we can have an Add Tile->once click on we need to Select the tile type
Here we need to create an application.
Select the required catalog from the input selection
Note: In the Target mapping section Semantic Object should be the same as in the UI.Identification annotation.
Once click on the SAVE button, a tile can be created in the ZCAT_TEST.
Now, we have completed the Generic Drilldown Report creation.
We need to deploy our OVP application into the system and need to create the Tile Fiori Launchpad Designer in the same catalog(here ex: ZCAT_TEST ).
Now available Analytical tile in the Test catalog,
This is the output of the ZOVP_DEMO -Overview application, Once click on the header or chart it will navigate to the Generic Drilldown report.
Conclusion: We need to develop Fiori OVP Cards with XML Annotation using CDS
With the UI. Identification annotation we can maintain the SemanticObject and Action.
Create a Generic Drill down report using the Manage KPI and Report Fiori Application.
Add that report as a tile to the ZCAT_TEST catalog.
.Before deploying the WEB IDE OVP application we should copy Evaluation.ID from KPI Drill down and maintain same in the CARDS section in the manifest.json file then we can deploy.
In the Fiori Launchpad we can be clicking on the cards it will navigate to the Generic Drill Down report.