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

Open the report from the respective work center.
Go to the selection area and click on the value help for the variable XYZ.
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

We are currently working to enhance this feature so that such selections will work, however for now, 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.

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 Cloud for Customer core applications all versions