SAP Knowledge Base Article - Public

2679456 - Report Filters Not Working: Value Not Valid For Variable

Symptom

You are trying to use a report filter or selection, however the report shows an error message even though the value is a valid one. The most common error message is 'Value ABC not valid for variable XYZ' (ABC and XYZ stand for the value you entered and the variable from the report respectively).

Environment

  • SAP Hybris Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Open the report from the respective work center.
  2. Go to the selection area and click on the value help for the variable XYZ.
  3. Select a value and click on OK.

You will see the error message 'Value ABC not valid for variable XYZ' or face an inconsistent behaviour.

Cause

This is a decimal field, i.e. it contains numbers. However, you have added it to the report as a characteristic, for example by creating an extension field of type String which however contains numbers. Filtering on numerical characteristics cannot be fully supported and may result in a behaviour like this.

Resolution

Numerical fields should always be added to reports as key figures. If you need to filter or select some particular values, you can make use of key figure conditions.

See Also

2534002 - Error Message Value not Valid for Variable While Trying to Filter a Report

2586974 - Values Length Restriction in Reports

2541093 - Error in Embedded Report: Value not Valid for Variable

2193737 - Error Message Value not valid for variable Partner Company

Keywords

report selection, filter, variable not valid, value help not working , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign all versions ; SAP HYBRIS C4C CORE all versions