Validation and execution

The selected measures are copied on successful validation and execution of the macro. These are the validation rules:.

  • If the source is a Transactional Data/Order measure and the destination is a standard measure, only the transactional Data/order measure values are copied.
  • If the source is a Transactional Data/Order measure and the destination is also a Transactional Data/Order measure or Null, the Transactional Data/Order is copied. This includes the measure values (for the source and destination) and the transactional data/Order record.
  • If the destination is a Transactional Data/Order Measure and the Source is of other measure types, the measure cannot be copied.
  • For transactional Data:
    • The start date and end date of Period Label are matched with the ‘To Date’ (received/End Date) of the transactional data. The transactional data/orders with a ‘To Date’ within this period label are included.
    • The location node (and the children) is matched with the ‘To location’ of the transactional data. The Transactional data with a ‘To Location’ at the location node (if base node) or a child (if aggregate) is included.
  • If the source is a Market Intelligence measure and the destination is a standard measure, only the MI measure values are copied. The Event is not copied.
  • If the source is a Market Intelligence measure and the destination is also a Market Intelligence measure or Null, the Market Intelligence Event is copied and re-applied including the Notes created. Also:
    • Only the events which start and end within the specified period are considered.
    • The MI Event spreads the MI based on the Spreading options stored for the MI Event.
    • Events must be copied based on the chronological creation date. This process assists in maintaining the integrity of the Events and the subsequently spreaded values.

See the Advanced CopyMIEvent macro for more information.