After a query is created the user is receiving a red message and no information is fetched on the report.
SAP SuccessFactors Workforce Analytics
Reproducing the Issue
- Access the analytics tab;
- Go to advanced reporting;
- Select the query that is giving the error;
- Error getting preview on the object and results section.
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)
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.
Advanced reporting - Error getting query preview , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , Problem