SAP Knowledge Base Article - Public

2238185 - How to Create an Ad Hoc Report Export Job Schedule using the Last Modified Date and Expression Builder

Symptom

This KBA will show how you can create a reoccurring job schedule that will fetch data based on the modified date.
We make use of the Expression builder parameters in provisioning for this.

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

Environment

SAP SuccessFactors HCM Suite

Resolution

Requirements:

  • Report available (Ad Hoc Report);
  • Admin User with Provisioning Access.

Steps:

  1. Create an Ad Hoc report based on the Recruiting V2 Secured domain;
  2. Define a filter on the Last Modified Date field;

     ad hoc filter.png
  1. Create a Job via provisioning Managing Job Scheduler > Manage Scheduled Jobs > Create New Job;
  2. Enter the Job Name, Owner, Type and Parameters then Edit the runtime filter;


    new job exp builder.png
  1.  Select the desired parameters via the expression builder. In this case, Expression ${today}, Operator '-' and Pattern 7 Days;

    2015-11-02_15-24-47.png
  1. Fill in the remaining information in order to be able to submit the job successfully;
  2. The Job is successfully completed and depending on the job configuration you should have an output file (csv or xls) in your FTP server location with the Job Requisitions data, according to the Last Modified' field, for the last week.

Note: In case of reoccurring jobs ,you may want to set the start date on the same day you want the job to run on a weekly basis.

See Also

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

2193439 - Report Job Schedule from Provisioning - Reporting and Analytics. Ad Hoc / Report - Table

Keywords

job,schedule, expression, builder, parameters, ad, hoc, table, report, center, dynamic, date, token, last, modified , KBA , job schedule , expression builder , report schedule , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-PRV , Provisioning Changes , How To

Product

SAP SuccessFactors HCM Suite all versions

Attachments

ad hoc filter.png