importSupplementalCollectionData

Imports supplemental collection data from a file into the application.

Use the uploadFile command to upload the file containing the data to the default upload location. the import file format is as follows:

#Workflow
Workflow_Dimension_1_Name,Workflow_Dimension_2_Name,Workflow_Dimension_n_Name
Workflow_Dimension_1_Member,Workflow_Dimension_2_Member,Workflow_Dimension_n_Member
#Collection
Collection_Attribute_1,Collection_Attribute_2,Collection_Attribute_n
Record1_Attr_Value_1,Record1_Attr_Value_2, Record1_Attr_Value_n

For example:

#Workflow
Entity
9100
#Collection
Custody Account Code,Trade Currency Code,Account Description,Base Currency Code,CIC Code,IFRS 13 Tier,SII Portfolio Type,WPM Detailed NAV ID,WPM Asset Description
1,,,,111,,,,6

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 importSupplementalCollectionData "FILE_NAME""COLLECTION_NAME" "YEAR" "PERIOD" "[FREQUENCY_DIMENSION=MEMBER]" where:

• FILE_NAME is the name of a CSV file, available in the default upload location, that contains properly formatted supplemental data.
• COLLECTION_NAME is the name of the collection into which the supplemental data in the file should be imported.
• YEAR is the year dimension member to be used for collection.
• PERIOD is name of the period dimension to be used for collection.
• FREQUENCY_DIMENSION, optionally, is the name of the frequency dimension to be used for collection. You may specify as many frequency dimensions as needed in "FREQUENCY_DIMENSION1=MEMBER" "FREQUENCY_DIMENSION2=MEMBER" format.

Example

epmautomate importSupplementalCollectionData "datafile.csv" "Journal Data Collection" "FY20" "Jan" "Account=PAYROLL" "JournalID=LNR 113"