Importing Dimension Members for Enterprise Journals

You can import dimension members into Enterprise Journals using CSV files. This helps to efficiently add, replace, or update dimension members and attributes in bulk, reducing manual maintenance.

Administrators and Power Users can import dimension members from standard flat comma-separated value (CSV) files.

To import dimension members:

1. On the Home page, click Application, then click Enterprise Journals.
2. Click the Dimensions tab on the left.
3. For a dimension, click the Actions icon and then click Members and Attributes.
4. In Members and Attributes window, click the Import icon.
5. Click Browse and specify the file you want to import.
6. Select one of the following options for Import Type:

   • Replace: Clears any dimension members in the journal and replaces them with the members from the source file. Any values absent in the source file will be blank after the import process.

   • Update: Updates only the members included in the source file. Other members are not affected.

7. Select a Date Format from the drop-down list of formats.
   Date formats are not translated. By default, the date format is set to the locale date format of the exported file location.
8. Select a File Delimiter for the import file: Comma or Tab.
9. Click Import.
   The Results screen displays the number of imported dimension members.
10. Click OK.