If you look at the process log you should be able to see the calculation script that is generated to clear the data.
Also if you want to run custom calculation scripts then have a look at Using Calculation Scripts
Thank you. I saw the clear statement in the log. It looks OK to me. Not sure why it's not doing a weird job of cleaning data.
What is a "Script Parameter" when I try to add a calc script in the Target application setting ? Currently there's no script parameter to display.
You should also be able to see in the essbase application log if the clear script is executing successfully and the number of blocks removed, if the FIX looks ok and there are no failures with the calc script executon then it doesn't look like a problem with FDMEE.
You will need to use runtime substitution variables in your calc script for them to appear as parameters, for example
The parameters should then be available.
Calc script is running now! thanks a lot.