Pushing Data from a Strategic Modeling Model to Multiple Strategic Modeling Models Using Data Maps

You can push data from a Strategic Modeling Model to Multiple Strategic Modeling Models using data maps. You can define Model to Model Data Maps that push data.

Administrators can create, edit, and run data maps using the procedures in this guide. Modelers can create, edit, and run data maps for models they have Modeler access to using the procedure described in "Pushing Data from Model to Model Using Data Maps" in Working with Planning.

To create Model to Model 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 Model.

    The Select Model page is displayed.

  5. Select a Strategic Modeling model and click Select.

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

  6. Under Target, select Models.

    Note:

    This option is available only when a Strategic Modeling model is selected on the source.

  7. Click Select under the Target section of the dimension mapping row for Model.

    The Select Members page is displayed.

  8. Select the Models 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.

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

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

  13. Click Save and Close