SAP Knowledge Base Article - Public

3049067 - Error: 'XXX' is restricted and cannot be added to the query happens when trying to add an object from C4C/ByD query in SAP Analytics Cloud (SAC)

Symptom

Error: 'XXX' is restricted and cannot be added to the query happens when trying to add an object from a sub-structure of an OData table in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2021.8
  • OData Import connection

Reproducing the Issue

  1. Log in to SAP Analytics Cloud tenant.
  2. Create a model based on OData connection.
  3. Select a query that contains a sub-structure.
  4. Try to add an item from the su-structure.
  5. Error occurs as 'XXX' is restricted and cannot be added to the query.

Cause

The sub-object is of type Collection which is not a supported Odata type in SAC.

Resolution

Only use objects that are listed as supported as per documentation: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/5c10ca68809c413087c39e9a6af39e24.html

See Also

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

Keywords

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, is restricted and cannot be added to the query, business analytics, reporting, report, data source, bydesign, odata, ap-rc-ana , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To

Product

SAP Analytics Cloud 1.0 ; SAP Cloud for Customer core applications 2002