Macro commands for a scenario

• Execute Demand Margin Analysis worksheet with default item, location, and period selection from worksheet definition and the e-mail PDF output to the user Scott.

• Execute Demand Essentials worksheet with default item, location, and period selection from the worksheet definition and e-mail XLS output to the user Harry.

• Execute Forecast Accuracy Analysis worksheet with Brand A item node, default location selection, and Rolling Weeks period node and e-mail PDF output to the user Harry.

• Calls the "New Engine" bypassing all engine setting defaults and calculations for all items and locations. Results are spread using the default spreading measure, if defined.

• Calls the "BATS engine" for valid SKU-level items under the Brand A node in the item hierarchy, for Customer-level locations under the US node in the location hierarchy, at a calendar level of Months. Spreading is not required, as the specified levels and the levels for storing scenario values are equal.

• Calls the "BATS engine" for the aggregated node Brand A in the item hierarchy, for the aggregated Region node US in the location hierarchy, at a calendar level of Months. Use the measure TUPLE_EXISTS to spread the resultant forecast output to the Cycle.level to store scenario values (if not equal to the specified item, location and period levels).

• Calls the "HW Engine" using the Best (ModelPick) algorithm, spreading results using the TUPLE_EXISTS measure, calculating all Product Groups and all Regions at monthly calendar level. SMPs are calculated by the measure SMPs <> 0 and call the CROSTONS algorithm. Parameter optimization is performed prior to the selection of algorithm and the forecast generation.

• All items at all locations from the current cycle period for the cycle period horizon.

• GOO items at all locations for calendar bucket "FY10".

• GOO items at all locations for the current cycle period bucket, for example, "FY10 M03" for 1 monthly period (if cycle calendar level = months).

• All items at US locations from the current cycle period for 52 weekly periods (if cycle calendar level = weeks).

• All items at all locations from calendar bucket "FY10 M03" for 9 monthly periods (if cycle calendar level = months).

• A null value for the bucket or calender bucket allows you to export all the data, for all the items, and all the locations, in the cycle period horizon.
  Note: When the direction is Export, the value of the Calendar Type parameter can be Null.

• Performs supersession for the definitions in supersession list, applying the changeover date to FINTRO for the successors and FDISCON for the predecessors; copying "HDMD" from all predecessor items to "HCOPYDMD" of all the successor items, at all specified locations, in the code list.

Copy all valid MI Events with a reference to Supplier MI, from the Demand-Baseline in the Normal May16 cycle period to the current scenario for all items at UK for FY 2016 location. All events at and below UK location, All Items, and FY 2016 rows, including the splashed MI values for the measure are copied. Any notes for the events are also copied.

Copy all Events created for the MI_1 measure from Finance-Baseline in the cycle period Normal May11 to the current scenario for all items at all locations for the cycle period horizon. All MI_1 Events as well as the splashed MI values for the MI_1 measure will be copied. Any Notes for those Events are also copied.

Copy all events created for the MI_1 measure from the Finance-Baseline in the cycle period Normal May11 to the current scenario for items, at all locations for the cycle period horizon to the MI_2 measure. All MI_1 Events as well as the splashed MI values for the MI_1 measure will be copied to the MI measure MI_2. Any Notes for those Events arel also copied.

Deletes all MI Events (including notes linked to the events). Also, clears all MI measures for items at all locations, for all periods of the cycle period horizon.

Deletes all MI Events created using the DPLS_MI measure. Also, clears the data in DPLS_MI and deletes any notes created for these Events for items at all locations, for all periods of the cycle period horizon.

Deletes all MI Events (including notes linked to the events). Also, clears all MI measures events created for GOO items (and events created for items below GOO) at all locations for the cycle period horizon.

Deletes all MI Events (including notes linked to the events). Also, clears MI measures for events created for All Items for the location, All DCs (and events created for locations below All DCs) for the cycle period horizon.

Deletes all MI Events (including any notes linked to the Events) and clears all MI measures for all items at all locations for the duration of the calendar period "FY 10" (Events starting and Ending within the calendar period "FY 10"). that is, any Events beginning and ending within the calendar period "FY 10" are removed.

Deletes all MI Events which have a reference "Easter MI" created against the DPLS_MI measure, clears the DPLS_MI of data and deletes any notes created against those Events for GOO items (and any events created at items below GOO) at location "US" (and any events created at locations below US) for the duration of the calendar period "Current Year" (Events starting and Ending within the calendar period "Current Year").

Deletes all MI Events which have a reference "Easter MI" created against any measures which are tagged against DPLS_AdvanceForecasting, clears the measures of data and deletes any notes created against those Events for GOO items (and any events created at items below GOO) at location "US" (and any events created at locations below US) for the duration of the calendar period "Current Year" (Events starting and Ending within the calendar period "Current Year").