Symptom
After fixing some validation errors in the Query Validation Tool, widgets on Story Designer page are still showing some errors.
Environment
SAP SuccessFactors HCM Suite
Reproducing the Issue
- Access report in Edit mode, see errors in the widgets
- Navigate to the Data source and Preview it.
- Upon Preview, one or more query validation error appears in the Query Validation Tool.
- Fix the errors with the Query Validation Tool until the report is previewable
- Navigate back to the Story Designer and see that the widgets still return errors.
Cause
Story Designer is not refreshed or widgets still contain fields already removed from the Data Source.
Resolution
This is an expected behavior as Query Validation tool only works for the query/data source.
Widgets on the Story UI still need to be fixed manually as fields previously existing in the Data Source may be used. For example, if some fields need to be removed from the query with the help of Validation Tool, they would need to be removed from the widgets manually afterwards.
It is also strongly advised that a Data Refresh is performed after modifying a data source, which will fix some errors on the Story Designer.
Keywords
Reporting, Report Stories, Stories, Query Validation Tool, Validation Tool, query, query designer, validation error, story, widget, error , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , Problem
SAP Knowledge Base Article - Public