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.