SAP Knowledge Base Article - Public

2936924 - Input Parameter on CDS Views does not work via Query Panel from SAP Analytics Cloud (SAC)

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

  1. Create a connection from SAC to S/4HANA via OData
  2. Having input parameter from the CDS views
  3. Try to import Data
  4. 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

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

Product

SAP Analytics Cloud 1.0