3224552 - Only one member is listed when trying to show value help dialog for one dimension in query built on OData Service connection to SAP HANA Cloud in SAP Analytics Cloud (SAC)

Only one member is listed when trying to show value help dialog for one dimension in query built on OData Service connection to SAP HANA Cloud in SAP Analytics Cloud (SAC).

• SAP Analytics Cloud (Enterprise) 2022.08.14
• SAP HANA Cloud

1. Log on to SAC tenant.
2. Create one model on OData Service connection to SAP HANA Cloud.
3. Create a new query.
4. Search for the problematic CDS View and then click Next.
5. In Build Query panel, drag the problematic dimension into Filters and the open Select Values For dialog => Only one value e.g. "2022-01-17T00:00:00.000Z" is listed. However, there should exist a value for the date e.g. 23 Apr 2022, too. 

• OData plugin captures the top 1000 records.
• Unfortunately, the top 1000 records returned by the client's datastore are the same i.e. that one date displayed in SAC.
• OData plugin does not go deeper than 1000 records.
• To check this run the query in Postman and notice that the top 1000 records returned by the datasource have the same timestamp value i.e. the only date being shown in SAC UI. The missing date that the customer is complaining about is probably deeper.

Review the OData settings and configuration documentations below:

• OData Hints for SQL Select Statements
• OData Configurable Cache Settings
• OData Entity Limits
• OData Batch Requests (XS Advanced)
• 2857920 - How to Troubleshoot Common Errors in SAP Cloud Integration OData V2 Receiver Adapter

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software https://help.sap.com/docs/SAP_HANA_PLATFORM/4505d0bdaf4948449b7f7379d24d0f0d/b6efb153ac8a4b96bb48baa14aa3e358.html , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem