Solution : https://service.sap.com/sap/support/notes/1631919 (Connexion à SAP Service Marketplace requise)
Résumé :
In an SAP HANA environment, a programming fault is identified with the "COUNT DISTINCT" operation in Calculation Views returning erroneous results under specified conditions. The error occurs in SAP HANA database Revision 10 or later when the “COUNT DISTINCT” is used in a calculation view with a WHERE-Clause that involves non-EQUAL operators or multiple conditions connected by "OR", and where the involved columns are not included in the "GROUP BY" clause of the statement. SAP is addressing this with a workaround suggesting adding the column from the WHERE-Clause to the "GROUP by" in the statement.
Mots Clés :
sap hana database revision 10, statement solution sap, wrong result reason, -memory database, hybrid database, correct result, prerequisites reason, solution asap, count distinct, calculation view
Notes associées :
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |