When you export to Excel, you cannot re-import in that format.
To export member mappings to Excel:
- From the Data Integration home page, click to the right of the integration, and then select Map Members.
- Click Edit.
- From the Dimension drop-down, select the dimension to which to edit or add member mappings.
- From the Export drop-down, select Export to Excel.
For the Export to Excel method, mappings are exported to a Microsoft Excel spreadsheet.
- Open or save the XSL file as desired.
- Click Export.