2495776 - Error getting query preview when date type is 'Related Table Options' set to 'Driving Table Start Date'.

SAP Knowledge Base Article - Public

2495776 - Error getting query preview when date type is 'Related Table Options' set to 'Driving Table Start Date'.

Symptom

Error getting query preview when date type is 'Related Table Options' set to 'Driving Table Start Date'.

Environment

SuccessFactors Advanced Reporting

Reproducing the Issue

  1. Create a new query in Advacned Reporting, using a non date ineffective table as the Driving Table.
    ex: EmployeeTime, Workflow Wf Request, etc.,
  2. Include fields from date effective tables in the same report.
    ex: Personal Information, Employment, etc., 
  3. Select 'Date Options' and change the 'Date Type' for 'Related Table Options' to 'Driving Table Start Date'.

    Date_options.png

Cause

We are instructing the system to use the effective date for the related tables, from a driving table that isn't date effective.

Resolution

Based on the requirement, set the Date type for related tables to anything other than 'Driving Table Start Date'.

Keywords

Error getting query preview 
Job Information
Driving Table Start date , KBA , LOD-SF-WFA-REL , Realms User Tool , Problem

Product

SAP SuccessFactors HCM Core 1702