Skip to Content
0

Wrong 'Group by' data result in HANA view

Aug 23, 2017 at 01:27 PM

53

avatar image
Former Member

Hello,

How can this be possible?

In the first SQL selection screen the result for TENDERAMOUNT should be equal to 492.5

As you can see, in the second selection, when I added TRANSNUMBER on the selection group the values changed and the sum is 492.5.

hana-view.jpg

Thank you for any help I can get

BR

hana-view.jpg (222.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Prashant Patil Aug 29, 2017 at 04:53 AM
0

Hi Paulo,

group-by-result.jpg

I tried creating the data for similar scenario and group by works fine for both kind of SQL queries.

Could you please provide the table/view definition of all fields on which you are writing the query.


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 31, 2017 at 09:20 AM
0

Thank you!

Sure, here it is

view-properties.png

view-fields.png


view-fields.png (89.0 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 31, 2017 at 09:28 AM
0

Just one more information

This view loads from another view, "OPER_GENERIC" and in that view we have calculated columns like so:

When I add this to the selection it bewaves as it should! This "Exception Aggregation Type" = "COUNT_DISTINCT" is somehow selecting it right. So, I asked end users to add this field to the report, but they don't want to. :-(

Is the lake of this in the selection responsible for the wrong figures?

Thank you!


ypnqd.png (20.3 kB)
Share
10 |10000 characters needed characters left characters exceeded