Question Re: Aggregation problem in graphical HANA calculation view in Technology Q&A

Aggregation problem in graphical HANA calculation view

stefan_voltz1 — Wed, 04 Aug 2021 10:07:08 GMT

Hello,

I am puzzled by the aggregation behavior in in the Join node of my graphical calculation view. I hope someone can give me a hint on how to get the result I expect.

The scenario is the following:

There are two projections I need to join. I am using an Inner Join.

In the Join node there is one Calculated Column RECORD_COUNT set constantly to "1".
The projection on the left (Druckbeleg_Kopf) contains the following data:
There are three document numbers (OPBEL).
The projection on the right (Druckbeleg_Abrechnungsbelege) contains the following data:
Each of the three document numbers (OPBEL above, PRINTDOC in this projection) contains four records with different BILLDOC values.
The RAW DATA of the Join node looks as expected. There are 12 records with all available combinations of OPBEL/PRINTDOC and BILLDOC.
So far so good.
In the Analysis tab, we can see the 12 records as well.
When removing field OPBEL, the aggregation of RECORD_COUNT looks as expected on field BILLDOC:
Now when removing field BILLDOC and dragging field OPBEL back into the labels axis, RECORD_COUNT is not aggregated as I expect.
I would expect the sum of RECORD_COUNT to be 4 for each entry in OPBEL. Because as we can see in the RAW DATA of the Join result, there are four records each.

Can someone explain why the aggregation behaves as it does?

And more important: Can anyone give me a hint to how I do get the result I expect? How do I get the aggregation of RECORD_COUNT based on the joined data set?

I appreciate any help.

Thanks a lot in advance 🙂

Re: Aggregation problem in graphical HANA calculation view

philippe_dobrowlanski — Tue, 19 Jul 2022 11:30:31 GMT

hello,

try to change the keep flag proprety to true on your field BILLDOC at the aggregration node.

Re: Aggregation problem in graphical HANA calculation view

former_member719934 — Tue, 11 Oct 2022 20:33:42 GMT

use keep flag property on BILLDOC

Re: Aggregation problem in graphical HANA calculation view

elitsy_01 — Tue, 26 Sep 2023 12:15:09 GMT

Did you solve this issue? If yes, can you please share the solution? I am struggling with the same issue.

@stefan_voltz

Re: Aggregation problem in graphical HANA calculation view

stefan_voltz1 — Tue, 26 Sep 2023 12:38:33 GMT

Hi Hani, yes I solved it using the keep flag. I hope this article helps you: https://blogs.sap.com/2017/08/30/usage-of-keep-flag/

Cheers,

Stefan