Variable limitations in Calc manager 2


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 11.1.2.1 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.


About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 thoughts on “Variable limitations in Calc manager 2