Validation and execution

The specified Cycle Period is restored for the selected Cycle and the status of the Cycle Period is set to Available on successful execution and validation of macro. Also, the scenario values and history are moved to the main tables, ensuring the scenario data is accessible in the worksheets

These are the execution rules:

  • If the Cycle Period parameter is defined, the selected Cycle Period is restored.
    Note: The status of the Cycle Period must be Archived.
  • If the Cycle Period parameter is not defined, the most recent Cycle Period with status Archived is restored.
  • If the Cycle Period parameter is not defined and the Cycle Period with status Archived is not available for the selected Cycle, the macro fails to execute.