This content has been marked as final. Show 3 replies
If you select merge as the load type then the default data clears will never run. Just code M as the load flag in the batch file name.1 person found this helpful
Hi SH, yes you are right, I also realised this in the car on the way home! But don't you mean "A" rather than "M" (for append)?
I have tested this and it appears to be the solution - setting the second character of the fifth segment of the filename to "A" has stopped the default Essbase clears from being executed. To summarise:
To append or replace to data in FDM:
FDM Web Client: Select "Append" or "Replace" option in drop-down list, respectively.
FDM Workbench Batch Processing: Set first character of fifth segment of filename to be "A" or "R", respectively.
To append or replace to data in Essbase:
FDM Web Client: Select "1 - Merge" or "0 - Replace" option in drop-down list in Export stage of workflow, respectively.
FDM Workbench Batch Processing: Set second character of fifth segment of filename to be "A" or "R", respectively.
Thanks for your help!
Yes it could well be A, I was probably thinking of the HFM adapter where it is definately M for target system loads even though the documentation states it should be A