SAP Knowledge Base Article - Public

2691625 - Contains "~" Operator Not Working in Report Selection

Symptom

When using the operator ~ "contains" in the report selection, no values are retrieved in report results.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Log into the system.
  2. Go to Business Analytics > Design Reports.
  3. Find and open the report XYZ.
  4. In the report selection pane, click the arrow on the left side of characteristic YXZ.
  5. Select the operator ~ "contains".
  6. Insert the text you want to filter by in characteristic YXZ.
  7. Click the Apply button to update the report results.
  8. See that no results show up in the report, despite you inserted the correct filter for characteristic YXZ.

Cause

You are inserting only a part of the text. For example, though you are looking to list all results containing the word "green", you are typing only "re" in the selection for characteristic YXZ.

Resolution

Whenever using the operator ~ "contains", you should insert the term between asterisks "*". For example: *re*.

See Also

Please also note that when using UUID fields like Opportunity or Account in the selection, you will need to enter the ID, not the description of the opportunity / account / etc.

Keywords

asterisk; report contains; contains operator report; business analytics; reporting; *; star , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions