Skip to Content

HANA Aggregation skipping lines

Greetings Experts,

I have a query regarding HANA aggregations. Currently, I am aggregation some amounts based on the Vendor Id and Vendor name.

From the business perspective I am expecting a total of 77 records, but when as I debugged I noticed that it is skipping three records,

Aggregating only 74.

See the image attached below

After searching, I noticed that It is skipping the three records. There are a few records that have the same amount. HANA is only choosing one of each, whereas the correct business behavior is to choose all three even if they have the same amount. See image below:

The three values hightlighted are skipped. Is there a workaround or a property that will not allow it to skip or is it just a design constraint?

Thank you for your help,

Luis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 10, 2015 at 08:18 PM

    Hi Luis,

    Is it a single table aggregation?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2015 at 08:58 PM

    while creating a calculation with Aggregation view I had added the Amt column using the add output option and the result set was,

    Prod_id   Amt

    1          10

    2          10

    3          10

    4          10

    When we used add as aggregate then the aggregation took place and the result for two amount fields of 10 for product id 1 was,

    Prod_id  Amt

    1    20

    2    10

    3    10

    4    10

    when we add it simply as output no aggregation takes place, when we add it as aggregated column only then the aggregation took place.

    Add comment
    10|10000 characters needed characters exceeded