importSDMDimensionMembers

Imports Supplemental Data Manager 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, Tax Reporting

Required Roles

Service Administrator
Power User

Usage

epmautomate importSDMDimensionMembers DIMENSION_NAME
                    FILE_NAME [ImportMode=Replace|Update] [delimiter=DELIMITER]
                    [dateFormat=DATE_FORMAT]

, where:

DIMENSION_NAME is the name of the Supplemental Data Manager dimension for which members are being 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 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 the 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 importSDMDimensionMembers Regions
                RegionMembers.csv delimiter=\t dateFormat=dd/MM/yyyy