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
- Go to the work center Business Analytics and the view Design Reports.
- Search and open the report ABC.
- Include the desired number of fields in the report.
- 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
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