Deleting a rule in Calculation Manager – Surprises in Calc Manager Part I 4


I’m sure people who love HBR are not going to like Calculation Manager a lot (but you don’t have a choice, do you?Winking smile).

I was not a big fan of it, however when I started using it I fell in love with it. I admit that there are some issues.

I wrote couple of posts (limitations) about Calc Manager, and the latest release solves one issue which I faced. There are some nice features in the latest release, launching MaxL scripts from a Calc Manger rule – to name one. I did promise that I’ll write about the new features, which will come soon (or later Smile)

This post is about (as the title suggests) a surprise in Calc Manager.

I’m sure by this time you are familiar with the Calc Manager terminology like “Deploy” and “Validate and Deploy”. If you are not have a look at Deploying Business Rules and Business Rulesets from the Deployment View.

When you deploy a Calc Manager Planning rule, it copies the rule from a table in Calc Manager’s repository called CALCMGRRULES to a table in Planning repository called HSP_CALC_MGR_RULES. (Well let’s say on a higher level this is what it does Winking smile).

Let’s imagine that you are getting a call from a user saying that he is seeing wrong values. You started looking at it and found that the numbers that appear there are derived using an old logic. (Which you are sure that you deleted them a long time ago).

You go back to Planning and what you see there surprises you.

All the old rules that you deleted are still there!!!!

Let’s prove it that you are not insane and you did delete them Smile

Proof
Below sheet is my input sheet and you can see that AggAll calculated the price for me as Revenue/Units.

excel values

I took a copy of AggAll rule and named it as “CAggAll” and made a slight change. (That was a mistake on purpose)

CAggall

Deployed the rule, so far so good

Entry from HSP_CALC_MGR_RULES

HSP_CALC_MGR_RULES

After some testing I realized that I made a mistake and deleted the wrong rule. The surprise starts from here. Now what happens when you delete a Planning rule in Calc Manager. Are you going to answer that it’ll delete the rule from Planning too? “Wrong answer”. You don’t believe me huh

Let’s make a copy of a Calc Manager rule and delete the original one. (Note: If you are planning to perform this, peform this only in a DEV environment and make a note of the access)

The rule will still appear in Planning(still there in HSP_CALC_MGR_RULES), what happens if the user who has access to it runs it?
I was expecting that it’ll throw some error. (John Goodwin was suggesting that it’ll run even when Calc Manager is down)

run deleted rule

It will execute the old rule (which was deleted) and will populate the wrong/old logic.

excel values new

Surprise, surprise….wouldn’t it be nice if it was automatically deleted?

How you can solve it?

Well unfortunately there is no easier way.
Don’t create new rules for new logic, just update the older ones.(I know you don’t do it just like the way I did/explained)
If you are ever deleting a rule from Calc Manager, make sure that you deploy all the rules in the application and it’ll ensure that the deleted rule is removed from Planning.

deploy full

Let’s hope that this will get fixed in a later release.
Advertisements

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

4 thoughts on “Deleting a rule in Calculation Manager – Surprises in Calc Manager Part I