Problems with @Aggregation.default: #SUM

[andresj6]

Hi experts,

I'm trying to add a row with the result of the summatory of a field using the annotation @Aggregation.default: #SUM but I have faced a great number of errors and now i am stucked. I will detail the steps that I have taken before arriving to the last error:

1. Add the annotation @Aggregation.default: #SUM into the field of the consumption view. -> Error: Transformation @OBJECTMODEL.VIRTUALELEMENTCALCULATEDBY on element DRAFTADMINISTRATIVEDATAUUID is not allowed in analytical views

This happens because when we use this annotation the view is transformed to an analytical view and then the objects takes an analytical key either than the semantic key.

2. Disable the draft functionality of the consumption view -> Error: Aggregation functions cannot be used in transactional views.

3. I erase the annotation from the consumption, add it to the interface view and repeate steps 1 and 2 -> same errors.

4. Based in this blog https://blogs.sap.com/2019/10/06/aggregation-using-cds-view-for-any-given-slice-and-dice-in-odata-pa... the annotation @Aggregation.default: #SUM should be used in the consumption view but the documentation says this about this type of annotations:

Aggregate functions are not supported in scenarios with projection CDS views. Aggregation annotations in projection view cause an error on service compilation. Aggregation annotations in projected entities are ignored.

Based on this, I will use it in the interface view, but I still have the problem because it is a transactional view.

5. In the documentation it is said that this type of annotations can only be used in views with dataCategory: #CUBE, #FACT, #DIMENSION. I add the annotations @Analytics.query: true and @Analytics.dataCategory: #FACT to the interface view -> I don't get the error caused by the transactional view but when I try to retreive data I get the next error: FETCH API (direct DB access) is not supported for entity ZI_ENTITY.

This problem is discussed in this blog https://blogs.sap.com/2019/01/24/error-messages-you-might-encounter-when-using-the-restful-abap-prog... but doesn't solve my problem.

¿Am I doing the correct steps to achieve what I want? ¿Is there any problem I have not faced correctly?

[Marissa]

Hi ajimenez11,

As tag SAP S/4HANA Cloud ABAP Environment is for S/4HANA Cloud public edition, I removed it. I added the tags in the blogs you referred.

Best regards,
Marissa

[Rui7]

HI,Did you slove your problem? Cause I meet the same problem ,i add @Aggregation.default: #SUM,@Analytics.query: true and @analytics.dataCategory: #FACT to the interface view, but I still do not get my total line in my RAP

[Louis-Arnaud]

Hello,

I guess that it is because you shouldn't use @analytics.query : true but the new way of creating analytics queries : https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/cds-analytical-projection-vie...