Blank result clicking on Show Preview while creating a Detailed Reporting query in ORD.
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
Depending on how much data the query has to load, the preview will hit a timeout after some minutes.
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.
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