Knowledgebase: Planning
Business Rules Error with many Members Assigned to Global Variable [ID 1228587.1]
Posted by Priya Doyle on 26 October 2012 01:44 PM
 
 


To BottomTo Bottom

Mar 12, 2012PROBLEMPUBLISHED3
There are no commentsComments (0) Rate this document Email link to this document Open document in new window Printable Page

 


Applies to:

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

Symptoms

When attempting to add many members to 'Default Value' of Global variable of Business Rule the following error occurs:
Error while sending command to HBR Server running within the EAS server.
Detail:com.hyperion.hbr.excp.DatabaseException.<init>(java.lang.String, [Ljava.lang.Object;, com.hyperion.hbr.excp.ExceptionSeverity, java.lang.Throwable)




Alternatively if you create variables to hold these selections the rule is unable to validate resulting something similar to:
Detail:Cannot calculate. Analytic Server Error(1200422): Error parsing  formula for [FIX STATEMENT] (line 3): expected type [BOOLEAN] found [MEMBER] in function [OR]

Cause

This is due to character limit on column in table HBRVARIABLES VALUE VARCHAR2(255).

Using custom list of members assigned to variable. 
eg. GVar1 "300000", "310000", "311000", "400000",...

Solution

Large cherry-pick-lists are not recommended due to table column limits and generated script size.  Instead Essbase functions should be used, hence the excluded section was added in the multi member selector to make it easier to build a selection using functions.

If the selection cannot be built using the children or decendants functions, use the @UDA function.  Members can be tagged with an UDA in the outline.
Storing the selection in the outline is safer than storing it in an Business Rule variable.

References

NOTE:757803.1 - Why Does Adding Too Many Values To Default Value Of Global Variable Fail?

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: