Skip to Content
avatar image
Former Member

Aggregation Behaviour Calculation View SAP HANA

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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?