Symptom
As a report designer, you can now receive real-time feedback on performance-heavy query designs, helping you to avoid anti-patterns that impact report efficiency. With this enhancement, designers receive warnings and are blocked from adding guard railed pattern elements once a set threshold is reached, ensuring optimal report performance.
The messages would be:
- You have reached the maximum limit of 36 nested IF conditions that can be used in a query.
- You have reached the maximum limit of 12 self joins that can be used in a query.
- You have reached the maximum limit of 7 nested calculated columns that can be used in a query. (Disabled as of 13th Feb 2026)
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental
Read more...
Environment
SAP SuccessFactors HCM Suite
Product
Keywords
KI2H2025, story reports, calculated columns, nested calculated columns, query designer, guardrails, limit, maximum, 7 nested columns, formula, query limits, Story report limitations , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview