SAP Knowledge Base Article - Public

3112952 - OData Error: only filter to multiple single values


When running an OData URL for your report, you face the following error message:

only filter to multiple single values


  • SAP Business byDesign
  • SAP Cloud for Customer


The default selection type of this field is "Multi-value", meaning that only single values or multiple single values can be used in the filter.

As a consequence, only the selection option EQ (equals) be used.

To check the selection type, please run a metadata query on your report and search for your characteristic. Check the property sap:filter-restriction="multi-value".


If you would like to use options other than EQ, you can consider the following workaround:

  1. Copy the report if it's standard, or edit it with the report wizard if it's a custom report.
  2. Go to step 4.
  3. Find your field and change the "Value Selection" to "Using Variable".
  4. Go to step 5. 
  5. Change the "Selection Type" to "Any Selection".
  6. Save this report.
  7. Now create an Odata URL which shows the metadata of your report, for example:
  8. https://<your system URL>/sap/byd/odata/ana_businessanalytics_analytics.svc/$metadata?entityset=RP<your report ID>QueryResults
  9. Search for your field and take note of the field ID. Note that it will be listed twice now, once with the usual characteristic ID, and once with a variable ID. The variable ID starts with PAR or PARA*. Please take note of the variable ID.
  10. Run your usual OData query once again, however replace the characteristic ID with the variable ID.

Now options such as NE or BT will work.


 property only filter to multiple single values, odata, error message, selection type, value help type, report, data source, build odata queries , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions