This is second post dealing with the Variable limitations in Calc manager.
I had to create a rule with limitations on variables that are used in the rule.
I’m using Sample Application to describe the issue.
Two variables are created, one to limit “Account” (@CHILDREN(CapitalExpenditures))
and another one to limit “Segments” (@ATTRIBUTE(“US_Electronics”))
This rule was running fine for couple of days and one day when I tried to run the rule, it gave me an error saying “One or more runtime prompt values are invalid.”.
However all the runtime values were valid ones and I opened up the “Select members” and found that the limits on the variable is removed. (I can see the entire “Account” and “Segments” hierarchy)
I checked Variable Designer to see whether someone removed the limits. But the limits were intact.
We had to search a lot to find a solution for this (restarting services,……..), atlast my friend and colleague Lingaraj found out the solution.
It was to unnlock the outline. (Yes someone locked the outline to search for some missing members).
I’ve checked this in Classic Planning applications and it seems to be working there, but with an EPMA 11.1.2 Planning application it is not. (EPMA 220.127.116.11 is also working fine)
Even though it is a good practice to unlock the outline, I’m curious to know whether anyone else has encountered this error.