Calculation Manager Fails to Export Member Block Variable

During a recent project involving Oracle Hyperion Enterprise Performance Management (EPM), we encountered an issue migrating Calculation Manager Rules via Life Cycle Management (LCM). While LCM did a good job of re-creating most of the variables used in the rule on the target, one variable didn’t make it. On further investigation we found that the variable is different from the others. Consider the rule of the format:

FIX ({var1}, {var2})
{var3} (

In this case, we found that the variables {var1} and {var2} would get exported from the source just fine, including their properties like limits, prompts, etc. However, {var3} does not seem to get exported.

When we tried exporting the rule via the Calculation Manager “System View” interface, we found that there too it would not export this variable. So the problem is not with LCM, but with Calculation Manager itself. On examining the XML file that is exported, there is a <variables> section that can be found at the beginning of the file. This section lists {var1} & {var2}, but not {var3}. However, {var3} is mentioned in the code block later on.

Oracle Support has been able to re-produce the issue in-house and have registered a BUG for this: Bug 18227617 – MEMBER BLOCK VARIABLE DOES NOT GET IMPORTED USING LCM; NOT SEEN IN VARIABLE LIST.

As a work-around to this, either create the variable manually on the target (a one-time thing if the variable is “Global”), or export/import the variables from Calculation Manager directly, and separately from the rules.

The good news is that this issue does not seem to exist in Calculation Manager I guess just another reason to keep up with upgrade cycles.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s