Group by clause in CDS view for large data set causing performance issues

[goel_ankur311]

We are trying to build a custom CDS view on CDS view P_ACDOCA_CUBE where we are trying to use Group by clause on certain fields. However, it seems to be causing a performance issue. Run time is increased for the same data set by a couple of minutes i.e. it's about 45 sec without group by & increases to 4-5 minutes with the group by clause.

Just to give some sense of the data volume it's like 1.5 million records.

Not sure if anyone has faced a similar issue and what would you recommend?

[todocalle4]

Hola, presento el mismo inconveniente.

I have a same problem.

how to resolver it is problem?

[ThorstenHoefer]

Hi,

it's dependend of your use case.

- can you use the "group by" outside the CDS?

- can you pass a parameter to the CDS view, to restrict your selection?

- can you use an analytic cds view?

[former_member837202]

Hi Ankur,

I have a similar issue. Were you ever able to solve it?