Symptom
- Try to import data from S/4HANA via OData into SAP Analytics Cloud (SAC).
- Happens only with the CDS view containing input-parameter at the Query Panel level.
- The same CDS view works fine using a Live Data Connection.
- The following errors occur:
- <CDS View> has failed to upload because of an error in the plugin service.
- errorCode: "PLUGIN_ERROR" errorDefinition: "{"code":"ERROR_FROM_EXTERNAL_SERVER","rawError":"Response from external server has status code of 400","params":["status:400 body:{\"error\":{\"code\":\"BW_BICS_EQ/132\",\"message\":{\"lang\":\"en\",\"value\":\"Incomplete URL; parameter or mandatory filter missing\"},\"innererror\":{\"application\":{\"component_id\":\"BW-BEX-OT-BICS.
- \\\"BW_BICS_EQ/114\\\",\\\"message\\\":{\\\\\\":\\\"en\\\",\\\"value\\\":"Select parameter supports only one argument with or without the text"},\\\"innererror\\\":{\\\"application\\\":{\\\"component_id\\\":\\\"BW-BEX-OT-BICS-EQ\\
Environment
- SAP Analytics Cloud
- SAP S/4HANA version 1909 FPS 01
- OData connection
Reproducing the Issue
- Create a connection from SAC to S/4HANA via OData
- Having input parameter from the CDS views
- Try to import Data
- Noticed the error when you select the objects at the query panel
Cause
- The Query Builder does not support input parameters via OData from S/4HANA
Resolution
- Use a Freehand Query to build the query and include the parameters.
See Also
- Import Data Connection to SAP S/4HANA
- 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 > Data Connections
- 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!
Keywords
CDS Views, OData, S/4 HANA , Input Parameters, SAC Importing Data, 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, BW_BICS_EQ114, BW_BICS_EQ 114 , KBA , views not working through sac , transactional cds views not working thro , s4 s4op s/4 , query has failed to upload because of an , plugin service , because of an error in the plugin servi , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-LDC , SAC Live Data Connection , BW-BEX-OT-BICS-EQ , oDATA Query / (Easy Query) , Product Enhancement