Creating Open Batches for Multiple Periods
You can use the open batch functionality to read file-based data sources with multiple periods and import them into the appropriate POV based on the file name. This feature enables you to automate the process of loading a large number of files. Open batches for multiple periods cannot contain jobs. Additionally, open batches for multiple periods can be scheduled to run periodically.
Files for an open batch multiple period load are stored in the inbox\batches\openbatchml
directory.
The names of multiple period batch files consist of the following segments in the following order:
-
File ID—A free-form field used to control load order. Batch files load in alphabetic order by file name.
-
Location
-
Category
-
Start Period
-
End Period
-
Load Method—A two-character item (Character 1 = append or replace, and Character 2 = target append or replace). Valid values are A and R.
Examples of open batch for a multiple period file name:
a_Texas_Actual_ Jan-2004_ Jun-2004_RR.txt (Loc, Cat, Start Period, End Period)
and
b_TexasDR1_ Jan-2004_ Jun-2004_RR.txt (Data Rule, Start Period, End Period)
To create and process an open batch: