SAP Knowledge Base Article - Public

2924676 - Not all values are listed to select for a Query when a model is created with S/4HANA On-Premise


  • Not all values are listed for a Query when a model is created with S/4HANA On-Premise. 
  • Only one of the values(the first one in the CDS view in the backend) is displayed in SAC. 


  • SAP Analytics Cloud (Enterprise) 2020.2.10

Reproducing the Issue

  1. Log on to the tenant.
  2. Create a model with S/4HANA On-Premise.
  3. Select query.
  4. Note only one value is displayed for "Select Values for".


  • This is the expected behaviour when on-premise source has lots of data where some data points have the same values.
  • The first 1000 values are returned by the system and if there are more values, the search functionality must be used. This is performance reasons. 
  • In this scenario, only one value is shown because the first 1000 rows returned had the same value for the data point on which being filtered.


This is by design.

See Also

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


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-PL , Planning , How To


SAP Analytics Cloud 1.0