2332211 - Scheduled Ad Hoc report for As Of Date and Date Range reports do not yield expected results.

• An Ad Hoc report has been built for one of the following domains and a scheduled job has been setup in provisioning for the same:
  Job Information (Date Range)
  Person and Employment Info (as of Date)
  Recurring Compensation Information (Date Range)
  Non-Recurring Compensation (Date Range)
• The scheduled run's output does not match with the output fetched from the instance by running it manually.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SuccessFactors HCM core
Ad Hoc reporting

• Obtain the scheduled run's output.
• Login to the instance and run the same report manually.
• The results do not match.

• The output of date effected reports (as of date / date range) depends on the effective date we select while running the report.
• When a job is scheduled for such reports, we (SuccessFactors support) get to choose between static dates and dynamic values.
• If the filter date has been set as a static one, irrespective of when / how many times the job runs , the output will always be with effect of the same date, yielding the same output.

• The effective date has to be a dynamic one / variable and It can be one among the following:
  
  endOfCurrentMonth
  endOfCurrentQuarter
  endOfCurrentYear
  endOfNextMonth
  endOfNextQuarter
  endOfNextYear
  endOfPreviousMonth
  endOfPreviousQuarter
  endOfPreviousYear
  lastSuccessfulRun
  startOfCurrentFortnight
  startOfCurrentFortnight
  startOfCurrentMonth
  startOfCurrentQuarter
  startOfCurrentYear
  startOfNextFortnight
  startOfNextMonth
  startOfNextQuarter
  startOfNextYear
  startOfPreviousFortnight
  startOfPreviousMonth
  startOfPreviousQuarter
  startOfPreviousQuarter
  startOfPreviousYear
  today
  tomorrow
  yesterday
• Additionally we can also include a (+) or (-) operator for Day(s), Month(s) or Year(s)
  
  
  
  
• Example 1: 'Person and Employment Info (as of Date)' report's schedule:
  The effective date for the scheduled job has been set as '${today} - 365 days'
  The report will always choose the date 365 days in the past, from the date the report is being run.
  If the report is being run on the 19th of June 2016, the 19th of June 2015 will be considered as the effective date.
  
  
• Example 2: 'Job Information (Date Range)' report's schedule
  The start date has been set to '${startOfCurrentMonth} - 1 Month(s)' and the End date has been set to '{endOfCurrentMonth}' + 1 Month(s)'
  The report will always include date for a span of 3 months - The Last month, Current month and the following month'
  If the report is being run on the 19th of June 2016, the actual start date will be the 1st of May 2016 and the End date will be the 31st of july 2016.
• Please review the options carefully and provide the same to us while creating a support case either for the initial schedule or for modifications of existing scheduled Ad Hoc report exports.

Ad Hoc report export
Scheduled Report
As Of date
Date Range
effective dated report , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-EC , Employee Central , Problem