53
4
Cli
ck
Ex
ecute or
C
reate Scr
i
pt.
See the section that follows for detailed information regarding these options.
Batch Controls
Batch Type—Determines if the batch being executed is a standard or a multiload batch. Standard
batch files are a single-month file that would normally be loaded through the import screen.
Multiload batch files are text or Excel files that can contain multiple periods and locations.
Process Level—Determines the level of processing to be performed. You can create a batch to
only import files, to process files, to running the check report step, or any step in between.
Process Method—Determines if the batch is loaded in serial or parallel mode. Serial batches
processes files sequentially, requiring that one file complete the process prior to the next file
starting. Parallel batches process multiple files simultaneously.
No. of Parallel Processes—Determines the number of processes the batch uses concurrently
when the Process Method is set to Parallel. Files within each process is executed in a serial batch.
Example:
If there are 20 files in the batch to be processed, and the No. of Parallel Processes is set to 5, then
five processes, each with four files, will run sequentially.
N
ote:
When processing batch files in parallel, FDM groups files that are loading to the same FDM
location into the same process. This ensures that a location does not have two processes
attempting to load data at the same time, potentially resulting in invalid results.
Load Balance Server—Allows the administrator to select any load balance server that has been
configured in the Workbench Load Balances Server group. This is the load balance server used
for processing the batch.
Auto-Map Correct—Allows the batch to have auto-mapping enabled or disabled for the selected
batch. This applies for all files in the batch being processed. FDM can auto map any item in the
batch load files that are not included the dimension maps. Any members that are not mapped
have a new map entry created in the location’s map for the unmapped member based on a
predetermined suspense account. To set up the suspense account, a new location named
AutoMapCorrect must be added to the FDM application. After adding this location, a new map
entry must be created in the Explicit map for each dimension. The source value for this mapping
must be named AutoCorrect while the Target value can be any valid member for the dimension.
These mapping entries are the basis for the auto mapping for any unmapped members of a batch
load.
File Name Delimiter—Defines what character is being used in the standard batch files names
to separate the five segments of the file name. In standard batch processing, the file name must
be set up in a predefined manner to allow FDM to determine the location, category, period, load
method, and order of processing. By defining these parameters in the file name, FDM can process
R
unn
i
ng Batch
L
oader
161