SAP Knowledge Base Article - Public

2940004 - Filtering is not Supported for Attributes of the Characteristics in Reports

Symptom

  • You are trying to Set Filter on the Attribute column added to the report.
  • You are trying to find the Attribute in the selection screen or under the available fields when you click on Filter.

Environment

SAP Business By Design

Reproducing the Issue

  1. Go to Business Analytics -> Design Reports.
  2. Open any Report. For Example let us consider the standard report Account Contact Data.
  3. Execute the Report. Go to View Section.
  4. In the Row Fields section, Click on (+) Add Fields to Row.
  5. Add a characteristic and its Attribute to the report. For Example : Account characteristic and its attribute Industry.
  6. Now Go to the attribute, Industry column in the report. Click on the column header.
  7. Choose Set Filter. You will get only the value list of the characteristic Account and not the attribute industry.

Cause

The current system design will not allow you to filter on Attributes. You can filter only on the characteristics added to the report.

Resolution

You can add the attribute as a characteristic to the report. Follow the steps given below.

  1.  Execute the Report.
  2.  In the top left corner, Click on Configure -> Add Fields.
  3.  In the pop up window search for the attribute . (Example : Industry).
  4.  Check the checkboxes for Display in Report and Display in Selection.
  5.  Click on OK.
  6.  Now in the Row Fields, you will find the attribute added as characteristic. (It will be available as Industry (Account)).

 You can now set filter on this column where the attribute is added as characteristic. Also this field will be availble under Filter in the selection screen. It allow you to filter the values.

Keywords

Filter, Attribute, Selection, Value help, Set Filter, Filter, characteristic , Add Fields , Add Fields to rows, Column filter, Inaccurate, Wrong Values , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions