3667892 - Incorrect Error Message Displayed When Self Join Limit Is Reached in Story Report

While creating or editing Story Report queries, the following error message is displayed:

"You have reached the maximum limit of 5 nested IF conditions that can be used in a query."

This message appears when attempting to add more than 5 self joins.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

SAP SuccessFactor HCM Suite

1. Create or edit the data source of a Story Report.
2. Add multiple self joins to the query.
3. Once the number of self joins exceeds 5, the system blocks the next join.
4. The following incorrect message is displayed: "You have reached the maximum limit of 5 nested IF conditions that can be used in a query."

The guardrails feature is designed to block additions only when the defined limits are exceeded (12 self joins). However, due to a defect, the system prematurely enforces the limit at 5 self joins. Additionally, the error message displayed is incorrect, referencing the nested IF condition limit instead of the self join limit, which leads to confusion for report designers. 

The Product Management team has disabled this feature while both issues (the incorrect limit enforcement and the misleading error message) are under investigation by the engineering team.

The What's New Viewer page will be updated with the new enablement date.

Guardrails in Story Reports

You have reached the maximum limit f 5 nested IF conditions that can be used in a query, KI2H2025, Story Reports, guardrails, complex queries, self join limit, nested IF conditions, error message, incorrect error, query design, query restriction, query builder , KBA , @release , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem