SAP Knowledge Base Article - Public

2545105 - Unable to export from Advanced Reporting

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

  1.  Access Advanced Reporting
    Analytics > Analytics / Reports > Advanced Reporting
  2. Create a new query or open an existing one.
  3. Try exporting the query's output.

    Export.png

  4. A popup window opens and displays an error after a while.

    error.png

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/1708/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:
https://help.sap.com/viewer/deb510367ec844b4bc84b8c52442f5e5/1708/en-US/b27ef920fd1f40efaf390ad33a6d0ff6.html


Keywords

Advanced Reporting
Query export Failed
Time out error 
Connection failed , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Suite all versions