SAP Knowledge Base Article - Public

2797183 - SAP Analytic Cloud OData it does not honor the Top and Skip values when using Freehand query


  • Trying to change the Top & Skip via Freehand query from SAC
  • Trying to change the chunk size to bring large data


  • SAP Analytics Cloud 2019.8.2
  • SAP HANA OData service 


  • The issue was on the Backend Server as results were significally better on QA vs Dev


  •  Review the differences among the backend being use.

See Also

Your feedback is important to help us improve our knowledge base.


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Bug Filed


SAP Analytics Cloud 1.0