SAP Knowledge Base Article - Public

3694967 - Not all data returned from LeanIX when using OData Query

Symptom

When the query should bring back 2000 records, the query only returns 289 records in SAC.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Create connection in SAC for SQL Databases using LeanIX configuration values
  2. Create new story with data and select the datasource just created
  3. Add fields from the datasource to a story and refresh it
  4. Only 289 records will be visible in the story

Cause

When OData batch size is set to 1000 in SAC which is the lowest value that can be set, anything less than 1000 records returned is assumed that the import is complete and does not attempt to request additional records.

Resolution

The datasource will need to meet at least the minimum batch size that SAC supports in order to work properly.

Keywords

LeanIX batch OData  , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud 1.0