on 08-10-2015 8:52 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Luis,
Is it a single table aggregation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.