SAP Knowledge Base Article - Public

2946028 - Characteristic Displayed as (Hierarchy) in Report Level and Original Characteristic Cannot be Selected

Symptom

You are looking to filter your report based on characteristic ABC (ABC represents the field name). However, the field cannot be selected and instead only field 'ABC (Hierarchy)' is available.

Environment

SAP Business ByDesign

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports work center view.
  3. Find and open the desired report.
  4. Go to the report selection pane.
  5. Note that both fields 'ABC' and 'ABC (Hierarchy)' are present in the Selection pane.
  6. Open the value help for field 'ABC'.
  7. There are no values displayed. Instead, only the field 'ABC (Hierarchy)' is working when value help is opened.

Cause

This behavior is caused by a personalization done from User level. From Add Fields option in the report, when the field 'ABC' is selected, the option "Display in Hierarchy" was enabled. When the hierarchy is enabled, first the field 'ABC (Hierarchy)' needs to be filled and then the actual field 'ABC' can be selected.

Resolution

If this is not the desired behavior, the user can simply unselect the "Display in Hierarchy" Checkbox in his personalization, from Add Fields option.

Keywords

Hierarchy Fields; Hierarchy Characteristic; Display in Hierarchy; Hierarchy Reports; Hierarchy , KBA , hierarchy fields , display in hierarchy , hierarchy , hierarchy characteristic , hierarchy reports , 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 ; SAP Cloud for Customer core applications all versions