SAP Knowledge Base Article - Public

2272348 - How to apply additional selection criteria (local filter) on the data set returned by standard filter in CompoundEmployee Delta Export excel

Symptom

How to apply additional selection criteria (local filter) on the data set returned by standard filter in CompoundEmployee Delta Export excel?

Only filter parameters supported by the Compound Employee API are passed on to the backend. Other filters are applied locally in Excel.

Sample filter "Cost Center" has been provided which can be used to filter out records which has "Cost Center" as mentioned in "Selection" sheet.

 

Environment

Successfactors System

Resolution

  1. Go to Config sheet.
  2. Go to Filters section.
  3. Based on your business requirement, you can either use "ANDed" or "ORed" additional filters.
  4. Filter XPath (Column 'B') can be defined as below:

     

1.JPG

      5.  Suppose you want to use Personal_Information/First_Name as an additional filter then you should define below:

           //personal_information[first_name='%EC_FilterAtClient_FirstName%']

      6.  Copy the text between %...%. In above example: EC_FilterAtClient_FirstName

      7.  Now, go to "Selection" tab

      8.  Insert a new row and give name for column 'B'. For e.g. "First Name"

      9.  Now, go to corresponding column 'C' and paste the text copied earlier as shown below:

 2.JPG

     10.  After pasting, press enter (from KEYBOARD).

     11. Once done, use the value you based on which you want to filter data:

 3.JPG

     12.  Save the changes and execute the query by clicking on "Get Data"

     13.  It should give expected result.

      

Keywords

KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Suite 1511 ; SAP SuccessFactors HCM Suite 1602 ; SuccessFactors HCM Suite 1505 ; SuccessFactors HCM Suite 1508