As with many solutions… it depends. “What a surprise,” you say. Your choice will probably be based upon your need, preferences, and also on how comfortable/proficient you are with writing batch scripts. If you need to execute a Data Load Rule(DLR) for one location as a part of a batch script, the answer will probably be “rundatarule.” If you need to execute DLRs for multiple locations, such as a part of a batch script to process monthly Trail Balances, then the answer becomes more subjective.
Using the “runbatch” command to execute multiple DLRs relies on the configuration of Data Load Rules, Batch Definition, and possibly Systems/Application Settings in Data Management depending on requirements. Using the “rundatarule” command to execute multiple DLRs requires coding the batch script to execute for each DLR. This will either require many individual “rundatarule” command lines or setting up the script to loop through a list of DLRs.
In this first of two blogs I will focus on using the “runbatch” command in a batch file. The command line to execute “runbatch” is:
epmautomate runbatch BATCH_NAME
The “BATCH_NAME” is the Batch Definition name listed in Data Management.
In the example I will be using there are only three Locations that will process files to a Financial Consolidation and Close Cloud application named “FCCS” (I know, very creative). The Locations are: FCCS1, FCCS2, FCCS3. The following items need to be configured before executing the “runbatch command:
- Data Load Rules have to be defined in order to assign them to the Batch (Name’s) Definition. Note: Both the specific File Name and Directory must be defined in each associated DLR.
2. The Batch (Name's) Definition needs to be added.
- On the "Definition" tab, configure the Name, Target Application, Type (Data), Execution Mode (Serial or Parallel) and Wait for Completion fields. Add the three (3) Batch Jobs that relate to the DLRs referenced in Step #1.
- On the "Parameter's" tab, configure the Import From Source, Export To Target, Start Period, End Period, Import Mode and Export Mode fields.
Note: This Batch Definition is configured to use the Start and End Period fields.
Note: A different way of achieving a load to one period can be accomplished by checking the “POV Period” checkbox and configuring the System or Application Settings’ “Global POV Mode”, “Default POV Location”, and “Default POV Period” fields.
The batch script contains the EPM Automate “runbatch” command line for the “FCCS_DATA” Batch Name.
The “RUNBATCH Script.bat” file was executed by a third-party scheduler, Windows Task Scheduler.
After the batch is executed, the Process Details logs indicate that all three (3) DLRs ran successfully.
That’s an illustration on how to utilize the “runbatch” command from within a batch script in order to execute multiple Data Load Rules in Data Management. In the next blog I will go over using the “rundatarule” command to accomplish the same results.