SAP Knowledge Base Article - Public

2313504 - Characteristic in Custom Report Doesn't Have the "But Exclude" Option


The option "But Exclude" is not available under "Advanced Selection" for a characteristic in a custom report.

Reproducing the Issue

When you open a custom report and click on the Value Help for a characteristic, the option But Exclude is not available under the Advanced Selection.


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


In order to correct the definition, please follow the steps below:

  1. Go to the Business Analytics work center and access the view Design Reports;
  2. Select the custom report 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.


KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


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