Hyperion Planning Business Rules
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