SAP Knowledge Base Article - Public

3334545 - Fixed Value Selections Using "Contains" Do Not Work in Report

Symptom

You have created fixed value selections in your report. However when you check the report after saving, you notice the fixed value selections are not working. When you edit the report again, the selections are changed to # instead of the chosen values.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the work center Business Analytics and the view Design Reports.
  2. Search for your report and edit it with the report wizard.
  3. Go to step 4.
  4. Check the fixed value selections you have maintained before. They show # instead of the values. 

Cause

You have maintained a fixed value selection on a UUID field, and you have used the "contains" (*) option.

Unfortunately, "contains" fixed value selections in UUID fields cannot be supported.

When you use "contains", a part of the text is used, however this partial text cannot be converted to a partial UUID in fixed value selections.

Resolution

You can consider the following options:

  1. Use the same fields as variables in the report selection. You can use "contains" in this case.
  2. Check if there are ID fields that you can use as a fixed value selection.

Keywords

report, business analytics, fixed value selection, not working, wrong value #, reporting , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Cloud for Customer add-ins all versions