Skip to Content
avatar image
Former Member

Wrong 'Group by' data result in HANA view

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 29, 2017 at 04:53 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2017 at 09:20 AM

    Thank you!

    Sure, here it is

    view-properties.png

    view-fields.png

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2017 at 09:28 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded