2556782 - Incorrect Export Results due to Filter in Data Workbench

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

SAP Cloud for Customer

1. Go to Customers workcenter
2. Go to Accounts view
3. Select the icon Advanced Filter
4. Choose the below:
5. Role: Prospect
6. Country: =PQR; =XYZ;
7. Select Go

There are a total of X records available.

Exported the X Prospects using the below steps:

1. Login to the HTML5 client
2. Go to Data Workbench workcenter
3. Go to Export tab
4. In the search field, select the object Account
5. Select Data
6. Select Filters
7. Country – Equals To – PQR
8. Country – Equals To – XYZ
9. Role – Equals To – Prospect
10. Select Next
11. The Total Records: Y
12. Where the Selection Conditions:
13. Account | customer.Country = PQR AND
14. Account | customer.Country = XYZ AND
15. Account | customer.Role = Object
16. Export Data
17. Go to the Monitor tab
18. Download the exported file

 The exported file contains Y Objects.

Incorrect filter used during the Export using Data Workbench. The attributes (Country in my example) in Data Workbench are handled using the logical AND.

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) 

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

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions