Symptom
Upon checking the Work center view for any object Z (for example Accounts, Opportunities etc.) via Advanced search, using any filter criteria, there are a total of X records. Your requirement is to export those X records using Data Workbench. Upon exporting the records using Data Workbench, you see Y records.
Example:
We are exporting the Prospects based on the Countries PQR or XYZ.
In Data Workbench workcenter, upon setting the Filter as below, the results are calculated as Y records.
Country – Equals To – PQR
Country – Equals To – XYZ
Role – Equals To - Prospect
You want to understand how to handle the same attributes (Country in my example) in Data Workbench, using the correct filters.
*Z represents the Object in Data Workbench
X represents the total records available in the workcenter view for the Object
Y represents the total records calculated for export in Data Workbench
PQR and XYZ represents the Countries
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Customers workcenter
- Go to Accounts view
- Select the icon Advanced Filter
- Choose the below:
- Role: Prospect
- Country: =PQR; =XYZ;
- Select Go
There are a total of X records available.
Exported the X Prospects using the below steps:
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to Export tab
- In the search field, select the object Account
- Select Data
- Select Filters
- Country – Equals To – PQR
- Country – Equals To – XYZ
- Role – Equals To – Prospect
- Select Next
- The Total Records: Y
- Where the Selection Conditions:
- Account | customer.Country = PQR AND
- Account | customer.Country = XYZ AND
- Account | customer.Role = Object
- Export Data
- Go to the Monitor tab
- Download the exported file
The exported file contains Y Objects.
Cause
Incorrect filter used during the Export using Data Workbench. The attributes (Country in my example) in Data Workbench are handled using the logical AND.
Resolution
Use the appropriate filter criteria during the Export using Data Workbench.
For the above use case, to Export those X Prospects using Data Workbench object Account, you may use the logical OR with the below filters:
Country – Is Any Of – PQR XYZ
Role – Equals To - Prospect
Where the Selection Conditions:
Account | customer.Role = Prospect AND
Account | customer.Country IN (PQR,XYZ)
Keywords
Filter in Data Workbench, Selection Criteria in Data Workbench, Filter Condition, Account , KBA , selection criteria in data workbench , filter in data workbench , LOD-CRM-INT-DWB , Data Workbench , Problem