Error getting query preview when date type is 'Related Table Options' set to 'Driving Table Start Date'.
SuccessFactors Advanced Reporting
Reproducing the Issue
- Create a new query in Advacned Reporting, using a non date ineffective table as the Driving Table.
ex: EmployeeTime, Workflow Wf Request, etc.,
- Include fields from date effective tables in the same report.
ex: Personal Information, Employment, etc.,
- Select 'Date Options' and change the 'Date Type' for 'Related Table Options' to 'Driving Table Start Date'.
We are instructing the system to use the effective date for the related tables, from a driving table that isn't date effective.
Based on the requirement, set the Date type for related tables to anything other than 'Driving Table Start Date'.
Error getting query preview
Driving Table Start date , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem