How can I append data during a Full Refresh import from an ERP System using two different Data Load Rules for the same FDMEE Location?
When I use a flat file I can import the file with the option of appending the data or replacing it, when I connect to an ERP system, the options change to Snapshot, Incremental or Full refresh. I understand why, I am not going to debate it.In my ERP System However, I have multiple source accounting entities which I can group, but I am not after this grouping either.
What I need to do is to append the data on the same FDMEE location using two data load rules one using an "ACTUALS" Ledger Group and the other using a "STATUTORY" Ledger Group. What I am currently experiencing is that the data gets wiped out during the Full Refresh import after running every import, the goal is to have all of the data saved in the same location in FDMEE not only in HFM.
Can anyone share ideas?