Symptom
ODATA query for report and data sources fetches only 50 records.
Environment
-
SAP Business ByDesign
- SAP Cloud for Customer
Reproducing the Issue
You tried to fetch data from a report or data source using an Odata query, but the result is restricted to 50 entries.
Cause
There is a restriction for the records fetch in ODATA to be 50 to avoid memory timeout. Hence an ODATA query for a report or data source will not fetch more than 50 records.
Resolution
You can bypass this limitation using the $top or $skip option. The $top=n where n is a number option specifies that only the first n records will be returned. Hence if you specify the $top=100 will return the first 100 entries. This might end up in a timeout for larger values for $top.
See Also
Please, refer the blog on ODATA for further information OData for SAP Business ByDesign Analytics.
Keywords
ODATA, 50 records, $top, $skip, restricted data retrieval , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To