1. Administering Planning
  2. Setting up Strategic Modeling
  3. Pushing Data from a Strategic Modeling Model to Multiple Strategic Modeling Models
  4. Using Microsoft Excel to Define Model to Model Data Maps

Using Microsoft Excel to Define Model to Model Data Maps

You can use Microsoft Excel to define the Model to Model Data Maps.

  1. Define the basic dimension mappings in the Data Maps page.

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

  3. Open the Exported Excel sheet containing Accounts, Source and Target Models.

    1. In the Selection sheet, update the Accounts and target models if needed.

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

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