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
nice post
Nice post indeed.