Symptom
As a report designer, you receive real‑time warnings when creating performance‑heavy Story Report queries. When guardrail thresholds are reached, the system displays warning messages and prevents the addition of further guard‑railed pattern elements, helping avoid anti‑patterns that negatively impact report performance. The following messages may be displayed:
- “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