Symptom
Error: 'XXX' is restricted and cannot be added to the query happens when trying to add an object from C4C or ByD query in SAP Analytics Cloud (SAC)
Environment
- SAP Analytics Cloud (Enterprise) 2020.8
- SAP Cloud for Customer
- SAP Business ByDesign
Reproducing the Issue
- Log in to SAP Analytics Cloud tenant.
- Create a model based on SAP Cloud for Customer or SAP Business ByDesign connection.
- Select a query to continue.
- Select the problematic object from the left Available Data panel, drag & drop to Selected Data area.
- Error occurs as 'XXX' is restricted and cannot be added to the query.
- Add the same object to Filter area, it works without error.
Cause
In a C4C or ByD report, you have 2 types of fields: Characteristics and key figures which can be displayed in the report view, and variables (also called parameters) which are used in the selection only.
The error message occurs because the selected field is a Selection Parameter, which should be only used as filter.
Checking the metadata about the ODATA for the SAP Cloud for Customer data service, it is confirmed for the problematic object, it has the attributes below which proved this is a Selection Parameter.
sap:selection-type="xxx" sap:selection="true"
Resolution
Only use this Report Selection Parameter in Filter area when building up the query in SAP Analytics Cloud. To check if a field is a variable or a characteristic, you can make use of the tools icon to display the description and ID of a field. If the ID of a field starts with "PAR" or "PARA", the field is a parameter (variable).
The tools icon is available in the "Available Data" section while you create the query in SAC.
Please also note:
If you have a characteristic and a variable with the same label in your ByD or C4C report, the SAC system will only display 1 of those fields. For this reason, it is strongly recommended to rename your variable if you intend to use it in SAC. To rename a variable, please proceed as follows:
- Log on to your ByD or C4C system.
- Go to the work center Business Analytics and the view Design Reports.
- Search for your report and click Edit with > Report Wizard.
- Go to step 5 ("Define Variables").
- Search for your field in this list.
- In the column "Rename Variable To", enter a unique label for your variable.
- Click Finish.
See Also
- 2913312 - How to Consume C4C / ByD Data Sources in SAC Using OData
- 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?
- 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 > 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.
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