Using Microsoft Excel to Define Advanced Data Maps

To simplify defining an advanced data map, use Microsoft Excel to define the data map.

  1. Define the basic dimension mappings in the Data Maps page.
  2. From the Actions menu, select Export Data Map.
  3. Update the Source and Target tabs if needed, and the detailed mappings in each tab of the Excel worksheet, and then save it.
  4. In the Data Maps page, from the Actions menu, select Import Data Map, and then save the data map.