Pushing Data from a Strategic Modeling Scenario Rollup to a Strategic Modeling Scenario Rollup

You can push data from a Strategic Modeling scenario rollup to a Strategic Modeling scenario rollup using data maps. You can define scenario rollup to scenario rollup data maps that push the data between the models of a scenario rollup for given business cases.

Administrators must have privileges to create, edit, and run data maps.

To create scenario rollup to scenario rollup data maps:

1. From the Home page, click Application, then Data Exchange, and then click Data Maps.

2. Click Create.

3. Enter a name and description for the data map.

4. Under Source, select the source for the data: Select Scenario Rollup.

   The Select Scenario Rollup page is displayed.

5. Select a scenario rollup and click Select.

   If you don’t see your Strategic Modeling scenario rollup in the list, from the Actions menu, select Synchronize.

6. Under Target, select the scenario rollup.

7. Click Select under the Source and Target sections of the dimension mapping row for Model.

   The Select Members page is displayed.

8. Select the models for Source and Target and click OK.

   Note:

   The target can be multiple models. You can push the data from one source model to multiple target models.

   If you don’t see your Strategic Modeling model in the list, from the Actions menu, select Synchronize.

9. Click Select in the Source section of the dimension mapping row for Account.

   The Select Members page is displayed.

10. Select the accounts and click OK.

    Note:

    Notice that selected Account Members are displayed in both Source and Target columns.

11. Click Configure. See Defining Account Configuration.

    The Edit Data Map page is displayed with the selected account configuration.

12. Update the default member values for Value, Time Periods, and Cell Text as required, and then click Done.

    Note:

    Business Case displays Any and cannot be edited.

13. Click Save and Close.

When running scenario rollup to scenario rollup type data maps, data movement happens with respect to business cases and contributing scenarios. The business case information is dynamic and is retrieved at runtime based on the business cases selected in the Run dialog, and data movement occurs based on the selected business case/contributing scenario between the source and target models for account/custom dimension selection defined in the data maps.

Note:

The Clear and Push Data option is not available for scenario rollup to scenario rollup type data maps. Scenario rollup to scenario rollup type data maps are only run from within the scenario rollup.