Recent Posts


Calculation Manager Fails to Export Member Block Variable
Posted on March 20, 2014
Author: Andy Tauro, Performance Architects

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.

Author: Andy Tauro, Performance Architects


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Leave a Reply

Your email address will not be published. Required fields are marked *