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 have privileges to create, edit, and run data maps.

To create Model to Model Data Maps:

  1. From the Home page, click Application Application icon, then Data Exchange Data Exchange icon, 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