Symptom
Blank result clicking on Show Preview while creating a Detailed Reporting query in ORD.
Environment
SuccessFactors Workforce Analytics (ANA) - All versions
Reproducing the Issue
-
Go to Online Report Designer
- Create a new Detailed Reporting query
- Add some fields to the canvas
- Click on Show Preview
- The result will display data as expected (limit to 100 rows)
- Add more fields from another table or subdomain schema
- The query will load for some minutes and the result will be blank
Cause
Depending on how much data the query has to load, the preview will hit a timeout after some minutes.
Resolution
This is expected behavior. The Preview mode has the same limitation as to run a report online (timeout of 5 minutes). The solution is to run the report offline.
See Also
Keywords
Blank result Show Preview while creating create report Online designer Detailed Reporting query in ORD timeout empty , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem
Product
SAP SuccessFactors Workforce Analytics all versions