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 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 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 open batch:
In the Batch Definition summary area, click Add.
Use the blank Name and Target Application fields in the Batch Definition summary grid to enter a batch name or target application on which to search.
In Batch Definition Detail section, select the Definition tab.
From Target Application, select the name of the target application.
In the Execution Mode drop-down, select Serial.
The serial execution mode processes files sequentially, requiring that one file complete its process before the next file starts its process.
In Open Batch Directory, specify the folder under inbox\batches\openbatchml subdirectory where the files to be imported are copied. If this field is blank or null, all files under inbox\batches\openbatchml are processed.
In File Name Separator, for an open batch type, select the character to use when separating the five segments of a batch file name.
Options:
~
@
:
;
Select Auto Create Data Rule to create the data rule automatically for file-based data loads.
When FDMEE assigns the data rule name, it checks whether a data rule with the “Location_Category ” name exists. If the name does not exist, FDMEE creates the data rule using the following file name convention:
Rule Name–Location_Category
Description–“Auto-created data rule”
Category–Category
File Name–Null
Mode–Replace
To use predefined data rules that load data based on specific categories, leave this field blank
Optional: In the Description field, enter a description of the batch definition.
Stage the file-based data source files by copying them to inbox\batches\openbatch using one of the following methods:
Predefined Data Load Rule—To use a predefined data rule that loads data based on specific categories, leave the Auto Create Data Rule field blank on the Batch Definition screen and create the data load rule (see Defining Data Load Rules to Extract Data).
If you have to load to noncontiguous periods in the open batch, create the data rule in which the source period mapping are defined, and use this option.
Next, create the open batch file name using the following format: FileID_RuleName_Period_LoadMethod. The file id is a free-form field that you can use to control the load order. Batch files load in alphabetic order by file name.
The load method is defined using two-character code identifying the load method where the first code represents the append or replace method for the source load, and second character represents the accumulate or replace method for the target load.
For the source load method, available values are:
A—Append
R—Replace
For the target load method, available values are:
A—Accumulate
R—Replace
Examples of an open batch file name are: a_Texas_Actual04_Jan-2004_RR.txt and b_Texas_Actual04_Jan-2004_RR.txt
Auto-Created Data Load Rule—To load data to any location category and have FDMEE create the data load rule automatically, create the open batch file name using the following format: “FileID_Location_Category_Period_LoadMethod”. In this case FDMEE looks for the data rule with the name “Location_Category.” If it does not exist, FDMEE creates the data rule automatically with the name “Location_Category.”
Auto-create data rule is only applicable for contiguous period loads. If you have to load to noncontiguous periods, create the data rule in which the source period mapping are defined.
Optional: Apply any scheduling conditions to the open batch file.
See Scheduling Jobs.
In the Batch Execution summary area, select an open batch file, and then click Execute.
After an open batch is processed, a directory is created, all files within the openbatch directory are moved into the new directory, and the new directory is assigned a unique batch ID.
Note:
The Open batch feature is unavailable for the Account Reconciliation Manager.