You first need to check that your source file does not have duplicate records as FDMEE would simply sum them up.
If your source file is fine. Then you need to ensure that the [Export mode] is set to “Store data” as the other options override all the data in the cube or just accumulate the data you’re loading with the data in the cube. Assumption you loading data into Essbase cube.
Please mark this response as helpful, or correct if it answers the questions to close the thread.
Some more information would be useful:
1) What is your Target Application i.e. Essbase or HFM etc
2) When you say 'FDMEE deletes all data except POV.' What do you mean as this doesn't really make sense in the context of how FDMEE implements Replace? As your POV for a Data Rule will be the target scenario, period (year & month) what your statement is implying is that all data in your target application is deleted except for the scenario and period in your POV. I assume what you are actually saying is that all data in the scenario & period in your target application is deleted except for the data that your DLR is loading. If that is the case then that is how the 'Replace' option is meant to work if your target is HFM
Thanks SH and User1211 for the quick reply.
Source is EBS and Target is planning application.
I checked the Data workload bench and there are no duplicates.
Here is the situation, user noticed that actuals for fy14 were doubled-up in Planning, so they ran the full fy14 actual load with the replace option, basically, it did fix the actuals for fy14, however, it also cleared the data for budget and forecast for all other fy.
our version is 220.127.116.11.500
"Replace" option only comes up in the Export when target is an HFM application. For planning application the options are Store Data, Add, Subtract, Override all Data. For your second issue - "it also cleared the data for budget and forecast for all other fy" I presume the user is exporting using Override all Data option - that's when all the data for that entire POV year (FY14 in your case) gets cleared from all scenarios.
For the numbers getting doubles up, there must be some issue with the export options being selected (maybe Add instead of Store Data) otherwise FDMEE will never double up data like this.
Sorry, Yes, it is "store data" option not replace.
Data load managed by finance users, now I' am curious that they might have mistakenly picked the wrong option, is there any place FDMEE captures these selections?
Try loking in the process logs
I tried searching with "Add", "Store data" and "Override all Data" but couldn't find anything. Is there any specific term FDMEE uses in the logs for these actions?
The clear statement will be sent to essbase search for FIX and you might find the code snippet if its set to clear all data it should be safe to assume your user chose that option
Ignore my last post I forgot the version you are talking about is 18.104.22.168.500. In that version FDMEE generates a load rule dynamically depending on the export option chosen. You could look a this but it gets overwritten on every load so unless the problem load was the last load you ran you'll get no joy from this