Symptom
For cases of complex integration scenario which requires :
(1) To filter Multiple field values from a customfield with non filterable property.
(2) Usage of a calculated filter to replace multiple if/then/else statement(s).
Using Value LookUp Table on Calculated Filter is an option
Note: custom field(s) with non filterable property is standard behavior for Odata APIs, in integration center the requirement can be achieved using calculated filter's post query result processing.
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 Integration Center
Reproducing the Issue
Use Case : Need to filter out records with ‘BestRun France (2200)’,’BestRun USA (3000)’ and ‘Null’ records from Custom Field 5 of User entity in the report.
Remarks : User Entity > Custom Fields are hardcoded set to filterable = false
Cause
Custom field(s) with non filterable property is standard behavior for Odata APIs
Resolution
See Sample Application for the Use Case mentioned.
First,see Original Output of Report without Value Look Up Table – Calculated Filter. Records for Users with ‘BestRun France (2200)’,’ BestRun USA (3000)’ are showing.
1.0 Apply Value Look Up Table – Calculated Filter
1.1 Go to Filter and Sort Tab > Advanced filter > Calculate filter
Select Field Value > Select your Custom Field you wish to apply the filter to
1.2 Then the put in the value lookup table the values NOT needed in report .
Items in screenshot of value lookup table contains ‘NULL’ and ‘BestRun USA and France’. The intention is to remove from the resport records with these value.
Note : Guide info link > Calculated filter is defined as a negative filter logic.That is, it filters out the value based on the condition, instead of filtering in
1.3 Now, see result Output Below.
Records are filtered from the report satisfying the requirement, working around the limitation for if/then/else statement allowed to be put in the calculated filter.
Note : Max Value Look Up table items is restricted up to up to 300 via CSV upload file using the Upload Sample CSV or Manually you can enter values up to 1000.
See Also
Keywords
Value LookUp Table, Caculated Filter, Custom Field Filter, Customizable Field Filtering, filterable=false , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To
Product
Attachments
Test Sample VLT via CF (1).docx |