Symptom
When the query should bring back 2000 records, the query only returns 289 records in SAC.
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Create connection in SAC for SQL Databases using LeanIX configuration values
- Create new story with data and select the datasource just created
- Add fields from the datasource to a story and refresh it
- 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
SAP Knowledge Base Article - Public