SAP Knowledge Base Article - Public

2604279 - Error getting query preview on Advanced Reporting

Symptom

After a query is created the user is receiving a red message and no information is fetched on the report.

Environment

SAP SuccessFactors Workforce Analytics

Reproducing the Issue

  1. Access the analytics tab;
  2. Go to advanced reporting;
  3. Select the query that is giving the error;
  4. Error getting preview on the object and results section.

Cause

This is caused because the user does not have the proper permissions for a table that is being used on the filters. (There is no field selected but the table is on the query)

Resolution

To determine which table is giving the error you can delete table by table and see if the report will fetch information. When the red message "Error getting query Preview" disappears the report is fetching data and that will be the table that the user does not have permissions.

Keywords

Advanced reporting - Error getting query preview , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors Workforce Analytics all versions