Different result for same query between HANA SQL Editor and Excel

[Former Member]

Hi,

I'm running a simple query and I notice the results are different (less) compare to what I have form HANA SQL Editor or Analytical Data viewer.

Here are the steps and the screenshot of each one is attached;

1) SQL From HANA SQL Editor, result shows 39421 (HANA SQL Editor.png)

2) Analytic Data Analysis view (Analytical Data Analysis view.png)

3) Excel (Excel using MDX conenction.png)

Could you help?

Thanks,

Niaz

[lbreddemann]

Hi Niaz,

an important first step in analyzing supposedly wrong result sets is to avoid comparing apples and oranges.

As Excel can only consume the analytic view but not pure SQL it doesn't help too much to compare the Excel result with the plain SQL result.

Instead, it would be more interesting to see the results of a SQL statement that queries the analytic view.

Unfortunately the data preview function does create a nested multi-grouped statement (you might check the statement via the "View log" button on the upper right corner of the data preview view) so that results are not necessarily comparable to those of your Excel report.

Therefore: what's the result of

SELECT 
"SalesTerritoryGroup",
SUM ("ResellerOrderQuantity")
FROM "_SYS_BIC"."adventureworks/AN_SELLERSALES"
GROUP BY "SalesTerritoryGroup";

?

- Lars