SAP HANA Scripts : Will the same resource in different columns selection cause different results?

[Kalos]

Hi Experts,

I am so confused about the results below. Same data resource and just add a count function in selection lead to quite different result.After I confirm the raw data, the result which select "YM",count("ID"),sum(Sales) is right.

I will pretty appreciate anyone help！

P.S. Mydata is from Oracle,connecting with HANA through SDI,and build an ADSO in HANA.

I use the ADSO with the SQL scripts.

# Select Year Month and Sum of sales,group by Year Month
SELECT "YM",SUM("Sales")
FROM "Mydata"
GROUP BY "YM"<br>

# Select Year Month count the id (id is unique)and Sum of Sales, group by Year Month
SELECT "YM",COUNT("ID") ,SUM("Sales")
FROM "Mydata" 
GROUP BY "YM"

[michael_eaton3]

What kind of object is Mydata?

[Kalos]

Hi Michael Eaton

the Mydata is from oracle ,connecting with HANA through SDI and build an ADSO in HANA.

I use the ADSO with SQL scripts.

[michael_eaton3]

Ok, as Mydata is an ADSO you might consider changing the tags associated with the question to BW.

The issue is likely the your combination of aggreagate SQL over the ADSO (but BW is not my area). Similar issues can occur when aggregating data in a query with a calculation view when you configure it as a cube rather than a dimension, often the solution is to remove the aggregate in the SQL as the calculation view is already summing the data.