SAP Knowledge Base Article - Public

2704247 - Only 50 Characteristics and Key Figures are Allowed in Reports

Symptom

You are looking to display over 50 fields when using a report, including characteristics and key figures, but system automatically reduces the number to 50.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the work center Business Analytics and the view Design Reports.
  2. Search and open the report ABC.
  3. Include the desired number of fields in the report.
  4. Once the total fields reach more than 50 in total, the following message appears: "Only 50 Characteristics and Key Figures Allowed in Reports; layout adjusted"

Cause

The current framework does not allow to add more than 50 fields in total, including characteristics and key figures, in the report UI. This behavior is designed to control the data volume and performance in reports, thus avoiding unexpected performance issues to be experienced in the system.

Resolution

When designing your reports and data sources, always respect the data limits which are indicated in the best practices suggested by SAP. Please follow up on the below KBA for details. This will always ensure the best performance when consuming your report data.

See Also

2366796 - Best Practices for Modelling Data Sources and Reports - Performance

Keywords

fields, reports, characteristics, key figures, amount, limit, Only 50 Characteristics and Key Figures Allowed in Reports; layout adjusted, Only 50 Characteristics and Key Figures Allowed in Reports, 50 fields in total , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions