SAP Knowledge Base Article - Public

2556782 - Incorrect Export Results due to Filter in Data Workbench

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 Hybris Cloud for Customer

Reproducing the Issue

  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.

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 , KBA , filter in data workbench , selection criteria in data workbench , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer all versions