1 person found this helpful
It appears the system is doing exactly what you told it do execute(after load) each time the load rule is used.
have you tried changing it from data load rule to location or some other item and retesting ?
Generally you'll have better luck with this in the FDM section, but your problem is that while you are passing the parameter to the Essbase Calc, you don't use them in your Fix.
I suspect it's not only running for all periods, but all years and versions as well.
Thanks for help guys,
The issue is with the parameters i defined..
These are the variables i have declared in calcscript
sp_year, sp_period and sp_version.
In FDMEE i am using these parameters.... ss_year, sp_period and ss_version. Silly spelling mistake.
Plus as Jeo123 said... i have to mention the variables in my fix statement too.... like below....
"No Future 1",
"Closing Balance - Actual",
Plus i don't know why i opened it in consolidation.... changing it to FDMEE.
Regards and thanks for help.