Skip to main content
hamburger menu Created with Sketch.
PHP2Shell - PHP Vulnerability Announcement || EU Holiday: Oct 23rd - Limited staff, please plan accordingly

Search the Knowledge Base

How to Remove an MC Cycle and its Associated Data in Veeva Align?

  • Updated

Question:

How to Remove MC Cycle and Associated Data in Veeva Align?

Answer:

The purpose of this article is to provide guidance as to how to remove an MC Cycle and all of its associated data.

Supposing an MC Cycle exists in Veeva Align with a Targeting Rule. This scenario is applied to the Production ("Live") and the Modeling environment.

Based on the Targeting Entity Relationship Diagram from Data Model:


The first set of steps is to extract data in the following order:

  1. Extract the Multichannel Cycle Plans (MCCPs) belonging to the MC Cycle.
  2. Extract the MCCP Targets belonging to the MCCPs.
  3. Extract the MCCP Channels belonging to the MCCP Targets.
  4. Extract the MCCP Products belonging to the MCCP Channels.
  5. Extract the MC Cycle Products belonging to the MC Cycle.
  6. Extract the MC Cycle Channels belonging to the MC Cycle.
  7. Extract the Targeting Rule Products belonging to the MC Cycle Products.
  8. Extract the Targeting Rule Channels belonging to the MC Cycle Channels.
  9. Extract the (Model) Account Rule Criteria belonging to the Targeting Rule Channels or Targeting Rule Products.
  10. Extract the Account Rule (This is the Targeting Rule record) belonging to the MC Cycle.

The next set of steps is to delete child records in the following order:

  1. Remove the MCCP Products belonging to the MCCP Channels.
  2. Remove the MCCP Channels belonging to the MCCP Targets.
  3. Remove the MCCP Targets belonging to the MCCPs.
  4. Remove the Multichannel Cycle Plans (MCCPs) belonging to the MC Cycle.
  5. Remove the Targeting Rule Products belonging to the MC Cycle Products.
  6. Remove the Targeting Rule Channels belonging to the MC Cycle Channels.
  7. Remove the (Model) Account Rule Criteria belonging to the Targeting Rule Channels or Targeting Rule Products.
  8. Remove the MC Cycle Products belonging to the MC Cycle.
  9. Remove the MC Cycle Channels belonging to the MC Cycle.
  10. Remove the Account Rule (This is the Targeting Rule record) belonging to the MC Cycle.
  11. Remove the MC Cycle.
Notes:
  • Removing MC Cycle data in Veeva Align is not recommended. Deletion should only be carried out if deemed necessary. For example, the concerned MC Cycle was created by a mistake.
  • It is recommended to use Vault Loader for these tasks.
  • There are other ways or methodologies to extract the data. It is possible to use vlookup in Microsoft Excel, or any SQL options to work with the data.
  • The MC Cycle and its associated data are hard deleted in Veeva Align.

Related Documentation:

Align Help Documentation:

Knowledge Base:

Powered by Zendesk