2875696 - Error "System query options '$skip' (or $expand) are not allowed in the requested URI" encountered in SAP Analytics Cloud (SAC)

When create a model in SAC based on C4C connection, if add Calendar Day, any ID and Description fields in the selected Data, will get the following error:

• The following error message comes from the external data service: status:400 body:{"error":{"code":"00145E5B1CC71EE0ABBBBBCC403C69E2","message":{"lang":"en","value":"System query options '$skip' are not allowed in the requested URI"}}}

        Or

• The following error message comes from the external data service: status:400 body:{"error":{"code":"00145E5B1CC71EE0ABBBBBCC403C69E2","message":{"lang":"en","value":"System query options '$skip' are not allowed in the requested URI"}}}

• SAP Analytics Cloud 2019.21.8

1. Create model and select SAP Cloud for Customer.
2. Select the C4C connection.
3. Select the query used in the customer's system.
4. Add the Calendar Day in the selected Data, or any other ID and Description fields.
5. Click Create, notice that the error encountered. 

• The root cause is the C4C odata service doesn't support some operators like $skip or $expand as stated in the error message. This is minimum requirement of any odata service as stated

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/5c10ca68809c413087c39e9a6af39e24.html

•  C4C driver uses odata underline, so it must meet the odata requirement.
•  So fundamentally, the odata service still needs to support the operators listed in the error messages like $skip or $expand.

In C4C OData queries, $skip and $top (which are used on SAC side) are not supported unless the data you are requesting from a C4C data source is unaggregated. For further details please check the following KBAs:

2822026 - Error in OData Query for Data Source: Skip Are Not Allowed In The Requested URL

2905293 - Error Message in SAC when Retrieving Data From ByD/ C4C Data Source

$expand is not supported on C4C side.

• 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 case for SAP Analytics Cloud?
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting 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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem