Importing Members from the Clipboard
This manual is in pilot operation.
|
To import member settings, including template members, from a Microsoft Excel sheet via the clipboard into a dimension, log in as [Manager] and select the target application. Then, follow the steps below to import the members.
Members can be imported from either the Dimension (Design) panel or the Dimension (Maintenance) panel, but note that if you import from the latter, only settings for user-defined members will be imported. |
-
Select the dimension you want to configure and display the Dimension (Design) panel (refer to "Viewing Dimensions" for the procedure).
-
Select the Member panel.
-
On the Microsoft Excel sheet, select the range that contains the data you want to import, and press Ctrl+C. You can also choose from Excel’s menu.
-
Click the From Clipboard button located at the bottom right of the screen.
The "Processing Status" dialog box will appear, and after a short while, the import process will complete. -
After the import is complete, click the Save button to save the settings.
|
If an error occurs during the import, it will be displayed in the processing status screen. Even if an error occurs, as many updates and registrations as possible will still be carried out. After the process is finished, you can manually correct the members and save, or discard the uncommitted updates and registrations by using the Retrieve button, modify the import data, and re-import. Even if no error occurs during the import, errors may still be displayed when saving. This is because the validation during saving is more stringent than during member registration or modification. If you want to check for errors before saving, click the Check button at the bottom right of the screen. |
