importEJDimensionMembers

Imports Enterprise Journals dimension members into a Financial Consolidation and Close application.

This command creates an import job using the command line parameters that you specify. Information on this job is available in the Job console.

Applies to

Financial Consolidation and Close

Required Roles

Service Administrator
Power User

Usage

epmautomate importEJDimensionMembers Dimension_Name
                    File_Name [ImportMode=Replace|Update] [delimiter="DELIMITER"]
                    [dateFormat=DATE_FORMAT]

, where:

DIMENSION_NAME is the name of the Enterprise Journals dimension for which members are imported.
FILE_NAME is the name of the source CSV file containing the member data of the dimension specified by the DIMENSION_NAME parameter. Use the uploadFile command to upload this file to the default upload location.
ImportMode, optionally, is the mode to use for the import operation. Specify:
- Update to change only the members included in the source CSV file. Other members are not affected.
- Replace, to clear dimension members in the form and replaces them with the members from the source CSV file. In this mode, values not available in the source file will be left blank after the import. This is the default mode.
delimiter, optionally, identifies the delimiter that is used to separate dimension members in the source CSV file. Default is comma (,). To use the tab character as a delimiter, specify \t.
dateFormat, optionally, specifies the date format to be used to convert the date or date time values, if any, in the source CSV file. Supported date formats are:MM/dd/yyyy, dd/MM/yyyy, d-M-yyyy, dd-MMM-yy, MM-dd-yyyy, and MMM d, yyyy, which is the default date format.

Example

epmautomate importEJDimensionMembers Regions
                RegionMembers.csv ImportMode=Update delimiter=\t
            dateFormat="dd/MM/yyyy"