Calculation Manager's "Merge Variables" Option does not Work for Local Variables [ID 839318.1]

---

 

 

Applies to:

Hyperion Planning - Version: 11.1.1.0.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Business Rule Ruleset option 'Merge Variables' does not honour local variables.

Cause

Local variables cannot be merged across Business Rules as they could represent different values although they have the same name. 

For example, the following shows a conflict if the local variables were merged: 

FirstHBR variable 'Name' -> used to store the Entity name 
SecondHBR variable 'Name' -> used to store the Account name 

If these variables were merged, the member selection menu would only show either the Account or Entity members. Subsequently one of the RTP values will be invalid and the calculation will fail. In other scenarios the calculation may not fail but produces wrong results.

Solution

To take advantage of this feature use global variables. In addition, Business rules which use global variables are likely to perform better. 

Planning users only: On Variables, select Merge Variables to merge all instances of the same variable 
used in the business rule so only the first instance of each variable is displayed when the rule is launched. 
If you do not select this check box, all instances of each variable are displayed. 

Note: 
If you select Merge Variables, the first value that the user enters for the runtime prompt is used 
for all subsequent occurrences of that runtime prompt during validation and launch.

References

http://download.oracle.com/docs/cd/E12825_01/epm.111/epma_admin.pdf