SAP Knowledge Base Article - Preview

3667312 - Guardrails in Story Reports

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

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Reporting 2511

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.