EPM Automate Import Supplemental Data, How to import supplemental data from a file

importSupplementalData

Imports supplemental data from a file into the application.

Use the uploadFile command to upload the file containing the data to the default upload location.

Applies to

Financial Consolidation and Close and Tax Reporting.

Required Roles

Service Administrator

Usage

Note:

All command parameters must be enclosed in double quotation marks.

epmautomate importSupplementalData "FILE_NAME" "DATA_SET_NAME" "YEAR" "PERIOD_NAME" "SCENARIO_NAME" where:

FILE_NAME is the name of a CSV file, available in the default upload location, that contains properly formatted supplemental data.
DATA_SET_NAME is the name of the data set into which the supplemental data in the file should be imported.
YEAR is the year for which the data set is deployed.
PERIOD_NAME is name of the period to which the data set is deployed.
SCENARIO_NAME is the name of the scenario to which the data set is deployed.

Example

epmautomate importSupplementalData "DatasetImport.csv" "EmployeeDataSet" "FY17" "Jan" "Actual"