« Importing Members from a File   |   Importing Members from the Clipboard »

Exporting Members to the Clipboard

Designer
This manual is in pilot operation.

To export member settings of a dimension to the clipboard, log in as [Manager] and select the target application. Then, follow the steps below to export the members.

The exported data can be pasted into a Microsoft Excel sheet, edited, and imported via the clipboard.

Members can be exported from both the Dimension (Design) panel and the Dimension (Maintenance) panel, and the functionality is the same in both cases.

  1. Select the dimension you want to configure and display the Dimension (Design) panel (refer to "Viewing Dimensions" for the procedure).

  2. Select the Member panel.

  3. (fusion_place >= 12.2) Set the member export format (this step is unnecessary if it has already been set correctly).

  4. Click the To Clipboard button located at the bottom right of the screen.

    The "Processing Status" dialog box will appear, and after a short while, the process will complete. At this point, the members will have been exported to the clipboard.

  5. On the Microsoft Excel sheet, select the appropriate cell (the top left cell of the range where you want to paste the exported data) and press Ctrl+V on your keyboard. You can also choose Edit(E)  Paste(P) from Excel’s menu.

    The exported data will be pasted onto the sheet.