SAP Knowledge Base Article - Public

2313504 - Not Possible to Exclude Values for a Characteristic in Custom or Standard Reports

Symptom

The option to exclude values is not available for a specific characteristic in a custom or standard report.

Environment

  • SAP Business by Design
  • SAP Cloud for Customer

Reproducing the Issue

When you open a custom or standard report, for example Sales Order Volume (technical ID CRMSLOIB_Q0001) and click on the drop down menu for the characteristic Account the option to exclude values (!=) is not available. You can select multiple accounts but not exclude values from the report

Cause

This is caused by the definition of the characteristic in the Report Wizard.

Resolution

In order to correct the definition in a custom report, please follow the steps below:

  1. Go to the Business Analytics work center and the view Design Reports.
  2. Select the custom report ABC that is presenting the issue and click on Edit With and select Report Wizard.
  3. Click on Next until you reach the step 5: Define Variables.
  4. Change the Selection Type of the characteristic from Multiple Values to Any Value.
  5. Click on Finish to save the report.

As standard reports cannot be edited please create a new report copy. Please follow the steps below:

  1. Go to the Business Analytics work center and the view Design Reports.
  2. Select the standard report for example Sales Order Volume (technical ID CRMSLOIB_Q0001).
  3. Click New > Report as Copy.
  4. Fill out the mandatory fields and click on Next until you reach the step 5: Define Variables.
  5. Change the Selection Type of the characteristic Account from Multiple Values to Any Value.
  6. Click on Finish to save the report.

See Also

Exclude selections take up more system resources than Include. Try to avoid the Exclude operator if possible, however if they are necessary, set them on fields of type ID, rather than UUID. So for example, if you need a negative selection (IS NOT) on the Employee field, make use of the field Employee Responsible ID, rather than Employee Responsible.

Keywords

variables; exclude values; variable; selection type; report wizard; step 5 , KBA , exclusion , is not , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions