I am using ERPi 22.214.171.124. In workspace it is possible to set the data load rule's option to be either snapshot, or incremental. However, I am using FDM/ERPi together to load data from Oracle GL into Essbase. Is there a way for me to set up FDM to have the data load rules do incremental data loads? Could this be a setting in the ERPi source adapter?
Thanks for any information you could provide.
Yes, in the ERPi source adapter there is an option for "Data Load Method" that will allow you to set how the DL rule is ran. BY default this is "FULL REFRESH" but can be changed.
A) Login to the app via the workbench and expand source system adapters
B) Right-Click on the ERPI Source Adapter and choose "options"
You will see a load method option and it will be set to Full Refresh, choose the option value you want from the drop down list and save.