Symptom
- How to edit reports that have Sub Queries in Advanced Reporting
- Table not run due to query complexity (contains sub query) message
Environment
SAP Success Factors Workforce Analytics (ANA) - All versions
Reproducing the Issue
You usually encounter this message when editing certain reports/ EC Standard Reports
Resolution
1.) Click the table to select the component and then right-click > Edit this component
2.) Right-click SUBREPORT and select Edit SubReport
NOTE: There cases whereyou would have to click on 'Click to Run' for the SUBREPORT to appear.
3.) Click on Data > Edit
4.) It will now direct you to the Advanced Reporting workspace wherein you edit the query and SAVE the changes made.
See Also
Keywords
Advanced Reporting, Sub Query, Realms, Employee Central, Query Designer, Report Designer, Table not run due to query complexity (contains sub query) , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem