HANA Cloud x Analytics cloud: Average and Median (wrong)

[yannmiquel]

Hello everyone,

Using HANA Cloud with a live connection to Analytics cloud, the aim is to retrieve the values calculated in HANA (calculation view). Sadly, the values displayed in SAC are not the same as in SQL.

SAC:

HANA (SQL)

Average

One column of the calculation view has a "AVG" aggregation type. Its value in SAC is not the same even if the aggregation type is set to "AVG".

Median

Since the live model in SAC does not propose MEDIAN, I try "NONE" as agregation type but it returns 0.

Conclusion

I have a feeling that there is no way to retrieve the results calculated in HANA (similar to "delegated" aggregation type). The only foreseen option is to calculate (again) the fields in the model, which is an issue regarding the data governance (since the formula would be defined at two different places).

Did you face similar issues with these calculations in this context ? How did you solve these ?
SAP HANA Cloud, SAP HANA database SAP Analytics Cloud SAP HANA Live SAP HANA Cloud 

[HakanHaslaman]

In SAP Analytics Cloud with a live connection to HANA Cloud, average and median values often differ from the HANA SQL results because SAC doesn't delegate these aggregations but recalculates them instead as I know; so the solution could be to pre-calculate the values in the HANA calculation view and set the aggregation type to "NONE" in SAC to avoid double calculation.