Hyperion Planning Error "You have selected an invalid business rule" When a Run Time Prompt With Variable Type 'members' is Used and Alias of the Member Contains an Ampersand (Doc ID 1680987.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

In Hyperion Planning application the following error is displayed "You have selected an invalid business rule" when a variable with variable type 'members' is used and the alias of the member contains an ampersand.

When a user selects a member in a Run time Prompt when running a Business Rule in Smart View the member quotes are not passed to value in RTP when the Alias has ampersand in the string. This doesn't cause the running of the rule to fail the first time, but then when the user tries to run the rule a second time (From Smart View or the Web - on ANY machine) then the prompt window doesn't appear and there is an error:

[com.hyperion.calcmgr.plugin.essbase.calcscript.TokenMgrError: Lexical error at line 1, column 9. Encountered: " " (32), after : "&"]

The only way then to get the rule to work is to redeploy the rule from Calc Manager. The issue occurs when ruining a rule in Smartview when a rule is attached to a menu.

The issue does not happen in the web interface if the rule is originally run from the web. The web is impacted only after the rule was originally run from Smartview.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms