SAP Knowledge Base Article - Public

2680346 - Advanced Reporting - Editing Sub Queries

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

screenshot_1.png

 

Resolution

1.) Click the table to select the component and then right-click > Edit this component

screenshot_2.png

 

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.

screenshot_3.png

3.) Click on Data > Edit

screenshot_4.png

 

4.) It will now direct you to the Advanced Reporting workspace wherein you edit the query and SAVE the changes made.

screenshot_5.png

 

See Also

2279026 - Employee Central Advanced Reporting Implementation Tips & Tricks from Support

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-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Core all versions