Batch File Name Format Specification

The information below provides a detailed list for each segment of the required batch file format.

Field Layout            

File ID-ProfileName-ScenarioName-TimeName-LoadMethod.txt

aTrialBalance-Houston;Import-Actual-2011M1-R.txt

Field Definitions and Values

File ID

Any text value used for file identification and controlling sort order.

Profile Name

A valid Import Child Workflow Profile name. Use a ; to delimit Parent and Child Profile names.

Houston.Import becomes Houston;Import

Scenario Name

This is a valid Scenario name passed to Data Sources using the Dimension data type Current DataKey Scenario. C can be passed as a substitution variable to reference the Scenario name passed in the function call: HarvestAndProcessFiles. G can be passed as a substitution variable to reference the Global Scenario name set for the application.                    

Using Current Scenario: A-Houston;Import-C-2011M1-R.txt      

Using Global Scenario: A-Houston;Import-G-2011M1-R.txt     

Time Name            

This is a valid Time name passed to Data Sources using the Dimension data type Current DataKey Time. C can be passed as a substitution variable to reference the Time name passed in the function call: HarvestAndProcessFiles. G can be passed as a substitution variable to reference the Global Time name set for the application.                        

Using Current Time: A-Houston;Import-Actual-C-R.txt    

Using Global Time: A-Houston;Import-Actual-G-R.txt

Load Method    

This is a value used to control how the file is loaded.

R = Replace, A = Append