SAP Knowledge Base Article - Public

2536012 - Order of the Attributes Under Characteristics Cannot be Changed

Symptom

Attributes in a report (the sub fields which come under the characteristics in 'Available Fields'), when added to Rows and Columns, cannot be moved up and down.

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Open a report.
  3. Go to Available Fields tab.
  4. Select an attribute under a characteristic.
  5. Go to the Rows and Columns tab.
  6. Click the attribute.

The options like Move up or Move Down are not available.

Cause

The order of a field added as an attribute cannot be changed. It will be placed next to the parent characteristic.

Resolution

One can add the same field as a Master Data reference instead.

  1. Go to the Business Analytics work center.
  2. Open a report.
  3. Click Add Fields.
  4. Select the field from the sub fields.
  5. This field will be added as a Master Data Reference  eg: DEF(XYZ) where DEF is the field and XYZ is the characteristic.
  6. Now go to Available Fields tab.
  7. Select the field DEF(XYZ) from the list.

The same field having the same data will be added as a Master Data reference. Order of this Master Data Reference can be changed in the list of Rows and Columns.

Please also note that removing a characteristic will force the attributes of that characteristic to show inconsistent results or no results at all. An attribute cannot work without the characteristic in the view.

Order of Master Data Fields.png

 

Keywords

order of characteristics, master data reference, attribute, rows and columns , KBA , 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