3684376 - QRC4 2025 - Avoiding OData inconsistencies when importing data in SAP Analytics Cloud

When data is imported into SAP Analytics Cloud (SAC) through an OData endpoint or any service that uses the OData protocol for data retrieval, inconsistencies may occur. These may include missing members, duplicated records, or aggregated values that appear to be doubled or tripled.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Analytics Cloud Enterprise 2025

OData, SAC, SAP Analytics Cloud, duplicate data, inconsistent data, pagination, nextLink, server-side pagination, $orderby, Freehand Query, import data, OData V2, OData V4, key fields, primary key, sort key, model import, data import issues, missing records, duplicated records, doubled values, tripled values, unstable ordering, deterministic sorting, OData limitations, S/4HANA OData, SAP Gateway, CDS OData, data acquisition, QRC4 2025, pagination settings, sort keys, primary keys, inconsistent results, model creation, data acquisition service. , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem