SAP Knowledge Base Article - Public

3382803 - Filters not working when using calculated fields in Integration Center

Symptom

You wish to understand why an Integration Center job which contains calculated fields is not displaying data in Preview mode, however when downloading the preview data the results are actually correct. 

Environment

SAP SuccessFactors Integration Center

Cause

Expected behaviour

Resolution

When it comes to the Calculated filter, its working approach differs slightly when displaying data in Preview. Calculated filters are applied on the data retrieved through the normal filters. For instance, when data is being previewed, the following steps are undertaken:

  • The initial dataset of the top 25 rows is fetched using the normal filters.
  • Subsequently, the calculated filter is applied to this subset of 25 data entries only.
  • If those data entries do not match the conditions specified in the calculated filter, the data will be absent from the Preview.

 

See Also

3035188    Integration Center not updating the data when job is scheduled normally (but works via "Run Preview Records")
3042857    Integration Center shows correct result in Preview but delivers wrong value in Output file (Run now)
Guide: Integration Center

Keywords

calculated filter, calculated filters, preview, calculated field, calculated fields, calculated, integration center, integration centre, IC, download , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , How To

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors HCM Suite all versions