SAP Knowledge Base Article - Public

2647027 - Blank result in Preview creating a report - Online Report Designer

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

  1. Go to Online Report Designer
  2. Create a new Detailed Reporting query
  3. Add some fields to the canvas
  4. Click on Show Preview
    show preview.png

  5. The result will display data as expected (limit to 100 rows)
    preview.png
  6. Add more fields from another table or subdomain schema
    add field.png
  7. The query will load for some minutes and the result will be blank
    timeout.png

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

2418819 - Reports Known Limitation and Best Practice for Ad Hoc - ORD - Online and Offline capabilities - FAQ

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