SAP Knowledge Base Article - Public

2362782 - Advanced Reporting report or query is taking a long time to load

Symptom

Advanced Reporting report or query is taking a long time to load (over 10 minutes) and is not efficient.

Environment

All Datacenters

Cause

Large reports will take time to process and render.

Resolution

1. Add filters to reduce the number of records returned

2. Reduce the time period for reporting 

3. Remove unnecessary columns to reduce the number of cells returned

4. Run the report in the background as CSV output

5. Run the report as a report distribution (using Report Distributor) - either scheduled or not

 

Keywords

KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics 1402 ; SAP SuccessFactors Workforce Analytics 1511 ; SAP SuccessFactors Workforce Analytics 1602 ; SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608 ; SuccessFactors Workforce Analytics 1207 ; SuccessFactors Workforce Analytics 1210 ; SuccessFactors Workforce Analytics 1302 ; SuccessFactors Workforce Analytics 1305 ; SuccessFactors Workforce Analytics 1308 ; SuccessFactors Workforce Analytics 1311 ; SuccessFactors Workforce Analytics 1405 ; SuccessFactors Workforce Analytics 1408 ; SuccessFactors Workforce Analytics 1411 ; SuccessFactors Workforce Analytics 1502 ; SuccessFactors Workforce Analytics 1505 ; SuccessFactors Workforce Analytics 1508