CDS View with annotation performance issue (Parameters / Filter annotations)

[Nicolas_Boucaud]

Hello,

I have a question about CDS View. I created an OVP (Fiori Elements) using CDS View with annotation and everything's working fine except that I'm facing performance issue.

I'm using CDS View "stacking" (CDS view calling the previous one) and because of a huge volume of data, the application is really slow to load. I assumed I had to filter the first CDS to reduce this volume.

Here is my screen :

Presently I am using filter annotation in the last CDS called (ZCDS_OVP_TBP_ALL_ANNO) :

//Join operations here//

then

Now I would like to filter the very first CDS (ZCDS_REV_YEAR) using "Company Code" parameter (bukrs) that the user enters in the input. This way I could reduce significantly the amount of data in my final CDS thus its performance.

How can I accomplish that ? I tried adding "@Consumption.filter" in the first CDS View (ZCDS_REV_YEAR)but it does not change anything.

Thanks for your help !

[abhi1185]

Hello Nicolas,

Did you get solution for same, actually I also have OVP application which is created using CDS view. However as soon as I added parameter to CDS, cards stopped showing Data. I have added OdataSelect paramter = true to all cards in manifest.json, also parameter is appearing, but nothing is getting selected.

[Nicolas_Boucaud]

Hello Abhishek,

does your use case prevent you from using filter annotations (@Consumption.filter) ? Because if not, I think it is the best way to go : simpler to use and appears to be as efficient as parameters (if not more).