SAP Knowledge Base Article - Preview

3791766 - SAP Analytics Cloud import from Datasphere returns inconsistent data due to non-unique sort key

Symptom

  • Importing data from Datasphere via OData into a Generic Planning Model shows inconsistent results when multiple FiscalYearPeriod values are selected (for example, full year).
  • Records are missing or duplicated in the model although they exist in the source; import jobs finish successfully without errors.
  • Single-period imports consistently load correctly.
  • Row counts and values for the same period range differ between executions when filters are changed on the same job.
  • No specific error messages are shown.


Read more...

Environment

SAP Analytics Cloud 2026.8.10

Product

SAP Analytics Cloud all versions ; SAP Datasphere all versions

Keywords

odata import, pagination, relational api, datasphere, sac planning model, missing records, duplicate rows, inconsistent row count, fiscal period, sort keys, primary key, uuid, data acquisition, analytical api, stable paging, S/4 HANA , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.