Skip to Content

Aggregation Behaviour Calculation View SAP HANA

May 05, 2017 at 12:25 PM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Thangaraj May 05, 2017 at 01:15 PM

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.


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?