Aggregation Behaviour Calculation View SAP HANA

[Former Member]

What is the difference (aggregation behavior) between an aggregation node directly under semantics and another aggregation node used in a (graphical) calculation view?

--> Is there a different aggregation behavior regarding calculated columns?

--> Is there any setting for calculation after aggregation in an aggregation node?

[Former Member]

Both should work the same way;

All calculated columns in aggregation node would be calculated after aggregation by default - you can't change that; If you need calculation before aggregation, then use projection node with formula before the aggregation node.

You may use the stacked nodes to meet your biz requirements - but that doesn't change the functionality of the nodes - it remains same.

[Former Member]

Thanks a lot for your quick repsonse! Unfortunately I have a different aggregation behavior. I have created a calculated column and in the aggregation node under semantics the result is calculated on an aggregated level and correct. In the other aggeration node the calculated column is calculated before aggregation, which is not correct. It is also the same result if I change the node to projection.

[Former Member]

What is your level of aggregations between these two aggregation nodes? Also can you please let us know the purpose of bottom aggregation node, other than top aggr. node?