Exporting the Map to Excel

When you export to Excel, you cannot re-import in that format.

To export member mappings to Excel:

  1. From the Data Integration home page, click Image shows Select icon. to the right of the integration, and then select Map Members.
  2. Click Edit.
  3. From the Dimension drop-down, select the dimension to which to edit or add member mappings.
  4. From the Export drop-down, select Export to Excel.

    For the Export to Excel method, mappings are exported to a Microsoft Excel spreadsheet.

  5. Open or save the XSL file as desired.
  6. Click Export.

    Image shows exported maps in Excel.