Navigation from OVP card to KPI Drilldown report

[prashanth01]

Hi All,

Please refer to my first blog:

Fiori OVP Cards with XML Annotation using CDS

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

we need to provide the Semantic Object in the Target Mapping Section.

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.

 

Post-deployment we can create a tile for that OVP cards application.

In the Fiori Launchpad we can be clicking on the cards it will navigate to the Generic Drill Down report.

Happy Learning:).

Thanks,
Prashanth