Calculation Manager rules locked by “which” User


I think you may have faced this problem where you were trying to figure out who locked a Calculation Manager Rule.
Since Calculation Manager doesn’t have an mechanism to tag whether you are “Editing” the rule or just “Viewing” it. I think going forward there should be an option similar to Essbase whether you get an option of “Edit”/”View”.
So if you open a rule it’ll add a tag saying that “This rule is been edited” and will not allow anyone else to change it.
There was a situation where I had to update a rule and it was in a locked state (Viewed/Edited by someone), I couldn’t figure out who locked it, so instead of sending out mails to all Administrators/Users I thought of looking into the Relation Tables (as usual 😉 )
I was thinking that there should be a table where it tags a rule as “in edit state”.
So here you go, Run the below given SQL statement and you can figure out who locked the rule.
SELECT NAME, OPENFOREDITINGBY FROM CALCMGRRULES WHERE OPENFOREDITINGBY IS NOT NULL;
You can also check for the same for the given components in the following tables

  • CALCMGRTEMPLATES
  • CALCMGRFOLDERS
  • CALCMGRCOMPONENTS – Scripts and Formulas
  • CALCMGRVARIABLES
  • CALCMGRSEQUENCES

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 “Calculation Manager rules locked by “which” User