Symptom
Users are unable to export data from Advanced Reporting.
After clicking the export / download button, a new pop-up window appears and it eventually displays a connection error.
Environment
SuccessFactors Advanced Reporting
Reproducing the Issue
- Access Advanced Reporting
Analytics > Analytics / Reports > Advanced Reporting - Create a new query or open an existing one.
- Try exporting the query's output.
- A popup window opens and displays an error after a while.
Cause
The behaviour is expected.
Advanced Reporting is a query designer and is intended to be used only to design and preview queries.
It is not be used to export data.
It allows exporting data for preview purposes and will work only for smaller queries.
For queries with much data or complex calculations, the export takes significantly more time and results in a browser timeout.
Resolution
Please create a new report using the report designer and the add the Advanced Reporting query as List report component to it.
If you have report center enabled, please create a new Report-Canvas and add the Advanced Reporting query as List report component to it.
Even for reports, we suggest using the Run-Offline option (Preview the report and Run-Offline) or scheduling them if the report contains significantly huge data.
https://help.sap.com/doc/4f3cf9444a324d65957e93aef45633a6/latest/en-US/SF_EC_Adv_Rep_ORD_en.pdf
Scheduling Reports for offline run using the report distributor:
Report Distributor How to Schedule it
Scheduling Reports using the report center:
2464604 - Scheduling Reports In Report Center
Keywords
Advanced Reporting
Query export Failed
Time out error
Connection failed
Application Error
Data dump , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem