SAP Knowledge Base Article - Public

2250718 - Report Output differences between Ad Hoc reports that is run manually and automatically [schedule Job].

Symptom

You notice differences on the output when the exact same Ad Hoc report is run manually and automatically [schedule job]. Both reports don't have the same results between runs manually or automatically.

Environment

  • SAP SuccessFactors HCM Core
  • Ad Hoc Report
  • Job Schedule

Reproducing the Issue

  1. Run manually an Ad Hoc report offline by selecting the Required parameters "As of Date".
  2. Run the same report 'Automatically', via job schedule, in Provisioning without the  expression builder ${today} has been selected.
  3. Compare the two results downloaded and in this case we observed a diiference in the number of row between the two reports output. 

Cause

In this case the differences were caused by the different date used to run the report. The Expression Builder ${today} is not selected causing the report not picking up the current day [${today}].

Resolution

In this case the report output was synch up by setting the same criteria from the run online to the backend Job.

The job parameters were adjusted, from provisioning, as follow:

  1. Select your company
  2. Go to: Managing Job Scheduler
  3. Manage Scheduled Jobs
  4. Edit the the job that has the issue
  5. In the section "View Scheduled Job"
  6. Go to: Job Parameters >> Required Parameter >> Expression Builder
  7. From Expression select the ${Today}
  8. Click created
  9. Save

Keywords

Less Data in Adhoc Missing data in adhoc schedule job Adhoc run automatically has less data Less data in adhoc Difference in ouput data , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core all versions

Attachments

2250718.docx