Using Microsoft Excel to Define Scenario Rollup to Scenario Rollup Data Maps

You can use Microsoft Excel to define the scenario rollup to scenario rollup data maps.

1. Define the mappings on the Data Maps page.

2. From the Actions menu, select Export Data Map.

3. Open the exported Excel sheet and update it as needed:

   1. In the Selection sheet, update the Source Model, Target Model, and Account columns.

   2. In the Account Configuration sheet, update the accounts you modified in the Selection sheet.

      Note:

      For scenario rollup to scenario rollup data maps, instead of a Scenario column, there is a column for Business Case. The only value allowed in the Business Case column is Any. All values other than Any that are present in the Business Case column will default to Any when the Excel sheet is imported into the application.

4. In the Data Maps page, from the Actions menu, select Import Data Map, and then save the data map.