This content has been marked as final. Show 6 replies
Use a load rule and specify overwrite existing values. Set FDM to use the the load rule. Then choose merge as the load option in FDM this will ensure that FDM doesn't try to execute its default clear script found in the Load Action of the Essbase adapter. This should fulfill your requirement.1 person found this helpful
Ok this should work (we previously had the load rule set to "Add to existing values", which was causing the addition of values on reload as described above).
More critically, is there a way to disable users from selecting "0 - Replace" when they load data to Essbase from FDM (to prevent the default clear script from being inadvertently run)?
There are a number of ways
1) Set Merge as the default load option (this won't remove it but will mean users have to explicitly choose to replace.
Administration-->Load Method is the setting to change
2) In workbench go into the adapter options Choose LoadOptMethodVal option, go to the Control properties tab and remove replace from the value list. This will disable it for all users of locations that use the adapter
3) Edit the load action script so that based on User ID or assigned security level even if they choose the replace option it exits the function a provides them a warning in the information window.
Furthermore, it appears that the option in FDM (0 - Replace/1 - Merge) is only effectively switching the Essbase default data clear (On/Off) respectively. We now have the Essbase load rule set to "Overwrite existing values", so that even if we select "1 - Merge" in FDM, the values are overwritten in Essbase and the default clear is not run.
Excellent, many thanks for your help! Yes it appears that the FDM option I mentioned above is being switched on/off by the "LOAD" Action script which can be accessed in Workbench. I have also found the option list you mentioned so we can look at removing the "0 - Replace" option entirely too. Thanks!
One final question on this, how does one post a message to the information panel?