An interesting and quite useful functionality provided by FDMEE, Calling a calculation script once the data is loaded to a Planning/Essbase application (well the my co-worker Walid enlighten me,thanks buddy)
The actual documentation of the functionality is here Using Calculation Scripts
Under the Setup ->Register Target Application-> Calculation Script (3rd tab)
The actual documentation of the functionality is here Using Calculation Scripts
Under the Setup ->Register Target Application-> Calculation Script (3rd tab)
- So i did created a calculation Script in EAS by the name Con_GL_Bal
- Under Script name entered the script name
- Under the Calculation Script parameter, select the values you want to pass during the runtime. Oh yes you don't have to hardcore any values (example: Year,Scenario) aweeessssome...
- Select the scope, the available options are
Cool huh...yep pretty cool
- I did selected the Data Rule and selected the appropriate Scope for the rule
- Selected to run the scrip after the data load.
- And the Sequence, yes it does matter. Which allows to trigger the calculation in the order you specify
- I had all the data rules under a batch, so i ran the batch
The calculation script is called and ran successfully, yes i could see the result in my report as well in the data form :-)
Happy loading the data/fishing via FDMEE,
Thanks for sharing useful information..
ReplyDeleteFDMEE Online Training