We have defined the allocation rules containing multiple run-time variables. The intent is to pick the balances from current month multiplied by the stats coming from previous months to derive the value to be allocated. Hence we have defined two run time variable, values of which will be provided while running the allocation rule. The rule in calculation manager gets validated successfully and also gets deployed. But when attempted to run the run, it errors out with following error -
ERROR in rule execution: Cannot Perform Custom Calc. Essbase Error(1260046): Unknown Member {accounting_period} used in query
Error in Rule Execution. Cannot Perform Custom Calc. Essbase Error(1260046): Unknown Member {accounting_period} used in query
The variable, Accounting_Period is defined in the system at database level. And it has been working if only single variable is used in POV. But for above mentioned requirement now the variable is moved to Formula from POV and the allocation is not running successfully.
We looked at the metalink note - Intermittent Essbase Error(1260046) When Running Allocate General Ledger Balances (Doc ID 2212655.1)
But this has not helped as even after tabbing out and selecting periods from LOV, we are still getting the error.
Has someone come across such requirement and has anyone able to use multiple variables in formula while building allocation rules in Calculation Manager?