Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fix on a User Variable in HBR

3588477Jul 16 2018 — edited Jul 31 2018

Hi Experts,

I am working on On Prem Hyperion Planning version 11.1.2.4.0.79. I have defined a user variable in Planning as "PlanYear". Set it's preference value to "2018". In Form, i have enabled the Dynamic user variables check box and also selected the user variable for the dimension "Plan Year" as Plan Year: &PlanYear in the layout.

In the variable designer, i have defined a run time prompt as rtpPlanYear and set its default value to "&PlanYear". I am using this run time prompt in the BR in FIX statement. My intention is to hide this run time prompt when the business rule is launched. So in the BR also i set the default value of {rtpPlanYear} to "&PlanYear. However, when i execute the rule through a Menu, the prompt still shows. I have set the "hide Prompt" checked in the Menu.

How can i use the User variable directly in the FIX statement in the BR? If I use FIX(&PlanYear) , it throws error! If i user [&PlanYear], still i get runtime error. The above method doesn't seem to work since plan year still shows in the prompt. Any suggestions would be great!

Thanks,

Pete`

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2018
Added on Jul 16 2018
2 comments
518 views