SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

SuccessFactors HCM core
Ad Hoc reporting

Reproducing the Issue

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

Cause

  • 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.

Resolution

  • 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)

    dates.png

  • 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.

Keywords

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

Product

SAP SuccessFactors HCM Core 1605