Skip to Content
1
Former Member
Jan 17, 2014 at 06:17 AM

Irregular aggregation of measures in calculation view

1589 Views

Hello All,

We are having a table in SAP HANA, whose structure is as below. Above that, we have built a calculation view, in which the measure "Quantity in TNE" have been added twice in the output, one with aggregation type "SUM" and other with "MAX", defined at the Semantics Layer.

Loading Date Plant Code Material Quantity in TNE 2012-12-08 125 101422 1.77 2012-12-12 125 101422 2.36 2012-12-12 125 101422 2.37 2012-12-17 125 101422 2.28

So, we get the output for the calculation view as below:

From this output, when we remove "LoadingDate", we still expect "Quantity in TNE" to display the MAX value, i.e 2.37, but it is making the SUM of the quantities, i.e. 7.01


Kindly explain the same.

Best Regards,

Ram

Attachments

1.png (7.2 kB)
2.png (4.3 kB)