CPM Data File Batch Functionality

Both OneStream and Oracle EPM cloud provide the data file batch functionality to load the data.  The common ground is that they both need a specific file name format, others are different.

Choosing a Global Software Development Partner to Accelerate Your Digital Strategy

To be successful and outpace the competition, you need a software development partner that excels in exactly the type of digital projects you are now faced with accelerating, and in the most cost effective and optimized way possible.

Get the Guide

For OneStream, here are the steps:

1. Create batch processing extender business rule. Batch file processing is executed by creating an Extender Business Rule that calls the OneStream API function Utilities.ExecuteFileHarvestBatch. This function also accepts switches which control the level of Workflow processing execution
2. Create data management sequence. Batch file processing is executed by creating a Business Rule Data Management Step that calls an Extender Business Rule created in step one.
3. Create data file with this name format:                                                                                                                                                              ID-ProfileName-ScenarioName-TimeName-LoadMethod.txt
4. Load files to Batch\harvest folder. The access path is:                                                                                                                                System Tab|File Explorer|File Share|Applications|Application Name|Batch|Harvest
5. Execute the batch. Once the files have been copied to the Harvest folder, execute the Data Management Sequence created in step two and the files will be processed.
6. Scheduling Batch Processing. Batch file processing can run using the Windows Task Scheduler or any other scheduling tool an organization may use. This is accomplished by creating a PowerShell Script to execute a batch processing Data Management Sequence when called from the specific scheduling tool.

For Data Management in Oracle EPM Cloud, steps are:

1. Create data file with name in this format:                                                                                                                                                         ID-Location-DLR-ScenarioName-TimeName-LoadMethod.txt
2. Load file to the folder:                                                                                                                                               Inbox\batches\OpenBatch
3. Create an open batch
4. Execute the batch
5. You either can schedule the batch with the DM scheduling functionality or any other scheduling tools with script