Opening a Scenario in Excel

  To open a scenario's planning workbook in Excel:

1. In the Integrated Margin Planning Analysis Workbench, display a list of scenarios.

2. Do one of the following:

   • Click next to the scenario.

   • Click the scenario, click Actions, and select Analyze Scenario Name.

   The scenario's planning workbook is opened in Excel, and an Introduction tab is displayed. The Introduction tab lists the Margin Planning Analysis Sheets and the Assumptions Sheets associated with the scenario.

   The data initially presented in the analysis sheets is from the underlying predefined Integrated Margin Planning model. If desired, you can load the Integrated Margin Planning model with data specific to your business (see Loading Information into Integrated Margin Planning). This business-specific data can be sourced from financial planning systems or operational planning systems. If you load the model with your own data, the data is displayed in the analysis sheets.

   The following predefined Margin Planning Analysis Sheets are available:

   • Financials

   • Demand

   • Transportation

   • Production

   • Materials

   Note:

   For details on the content in the predefined Margin Planning Analysis Sheets, see Predefined Cubes.

   Note:

   For details on performing scenario analysis, see “Performing an Analysis” in the Oracle Integrated Operational Planning User's Guide.