Need logic for Ranking function in CDS view

[former_member592065]

having plant and no of errors per plant data and i want to display the data in rank wise, like top 5 error plant etc..

Please suggest some method or annotations to implement ranking function in CDS view.

[pfefferf]

In what area you are working (HANA CDS, ABAP CDS, ...)?

[giselle_lin]

Hi Prmiga,

This feature can be achieved by define condition in the query. So far query defined in CDS view has no annotation for condition. Therefore you can build a BW query with condition on the CDS provider.
See https://wiki.scn.sap.com/wiki/x/Qxd7H