Hyperion Planning (MOSC)

MOSC Banner

Hyperion Planning Business Rules

edited Nov 19, 2014 6:02AM in Hyperion Planning (MOSC) 5 commentsAnswered

I'm getting some strange results from some BR code and wondered if anyone could explain it to me:

/* Create variable and assign value of 1 to switch loop OFF or 0 to switch loop ON  */

VAR RunForecast=0;

VAR RunAllMonths=1;

FIX (

     @RELATIVE ("Division", 0),

     @RELATIVE ("Product", 0),

     @RELATIVE ("Entity", 0),

     {Scenario},

     {Year})

     "Working"

(

    IF({Scenario} <> "Forecast")

             RunAllMonths=0;

             RunForecast=1;

       ENDIF;

)

ENDFIX

with the code above, if the user responds "Plan" and "FY15", the RunAllMonths flag is set to 0 and the RunForecast flag is set to 1.  If the user responds "Plan" and "FY16", the statements w/in the IF are not executed.  I have looked in the app log and see that in both cases it's "seeing" the scenario as Plan, so I'm not sure why the IF statement is not being seen as TRUE.  However, if I use the following code, where &PlanYR is set to FY16 and &BudFcstYr is set to FY15, the IF test is TRUE and the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center