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

• The option to exclude values is not available for a specific characteristic in a custom or standard report.
• Unable to exclude values for a specific characteristic in a custom or standard report, receiving error 'Report cannot be opened. (KBA:1926357)' when you done with exclude action.

• SAP Business by Design
• SAP Cloud for Customer

• 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
• Open value help for characteristic XXX from selection, go to advanced filter, select 'is not' (exclude) for required values.

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

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.

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.

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

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