EPCM - Data Import and Export with a period range using EPM Automate

9:09AM

Hi All,

In Enterprise Profitability and Cost Management, I can load source balances for a range of periods in one go by specifying a start and end period in the UI using Data exchange. However, I can only find a single-period parameter in EPM Automate.

epmautomate importBalances DailyLoad "January 2025"

I want to load source balance data from Jan-25 to Dec-25. If I select start period as Jan-25 and End period ad Dec-25, same number of records will be loaded into workbench for all the periods and exported to Essbase as well.

Is there an EPM Automate command to load multiple periods at once, or do I need to write a script loop to call the load for each period? Or is there any way to handle this other than EPM automate. Eventually, I want to automate this.

EPCM - Data Import and Export with a period range using EPM Automate

Howdy, Stranger!