2333379 - How to Delete Marketing Attributes Using Data Workbench Work Center

SAP Knowledge Base Article - Public

2333379 - How to Delete Marketing Attributes Using Data Workbench Work Center

Symptom

This Document will guide you on how to delete Marketing Attribute assignment from Accounts using Data Workbench work center.

Environment

SAP Hybris Cloud for Customer 1711 and higher.

Resolution

The complete deletion of the Marketing Attribute assignment of an Account has two steps:

First step:

  1. Go to Data Workbench work center;
  2. Select Export view;
  3. Select object as Attribute Assignment Item;
  4. Select Business Partner ID under filters and add the ID to Value;
  5. Click Next;
  6. Click Export Data;
  7. Then select object Attribute Assignment and perform the steps from 4 to 6.

Add column "ToBeDeleted" to the end of both extracted templates with value "TRUE", the files should look like these below,

BusinessAttributeAssignmentItem:

2017-12-13_16-47-11.jpg

BusinessAttributeAssignment:

2017-12-13_16-49-40.jpg

Second step:

  1. Go to Data Workbench work center;
  2. Select Update;
  3. Select first object as Attribute Assignment Item;
  4. Select Next;
  5. Upload the template for Attribute Assignment Item;
  6. Click Update;
  7. Then select the object Attribute Assignment and perform steps 4 to 6.

Keywords

marketing, attributes, assignment, data, workbench, business, delete, remove , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-CRM-MKT-CNT , Marketing Content , How To

Product

SAP HYBRIS C4C 1802 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711