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 AdministratorUsage
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"