Error message 'value not valid for variable' while trying to filter a report even though in the report the value exists for the Characteristics.
Reproducing the Issue
- Go to the Business Analytics work center.
- Open a Report
Try to filter the report using a description value for a characteristic like Account, Product or Material.
You will get an error like 'value ABC not valid for variable XYZ'. (ABC represenets the description) (XYZ represenst the Characteristics)
The Characteristics like Account is bound to ID not with description though it displays both ID and description. Hence it can only be filtered with ID.
This is the expected system behavior.
As a workaround you can search for the Characteristic with description in value help
- Open the value help by clicking on the square help button on the right of the field.
- Search the description in the value help.
- Click OK.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To