This content has been marked as final. Show 2 replies
It's certainly possible with an event script but I would question if this really needs to be done. Could you not accomplish the same with an Essbase aggregation or member calculation?
The target Essbase application is a live system which the cleint has been using since a long time. The Essbase (which is actually a Planning system) is by design non-aggregating. The users load data at parent level as well base level through forms & via excel lock and send.
The actual data load in the current Planning system is being done from the source Essbase actuals engine through partioning (All level partition). I am working on replacing the existing Essbase actuals engine by HFM. Thus rather than brining any chnage to the live system the client wants me to do this in FDM anyhow.
Will the logic be after validate of before validate? Do I have to use a SQL using union or something similar? Please suggest.
Thanks & Regards,