Hyperion Essbase (MOSC)

MOSC Banner

Can one do an "if" statement in maxl?

edited Aug 29, 2019 9:22AM in Hyperion Essbase (MOSC) 2 commentsAnswered ✓

Hello,

Can one do an "if" statement in maxl, and what is the syntax?

I am trying the following, where $9 is a value passed in from the bat script. I know the execute calculation part works, because it runs when I do not have the "if".

if $9=="AUS" execute calculation $11.$12.FDMmvAPC with runtimesubvars "'FDM_Period=\"$6\";FDM_Year=\"$7\";FDM_Forecast=\"$8\";'";

When $9 is 657 for example, I get the following error:

MAXL> if 657=="AUS" execute calculation PLAN.GM.FDMmvAPC with runtimesubvars "'FDM_Period=\"Jul\";FDM_Year=\"FY19\";FDM_Forecast=\"Forecast_Aug\";'";

   ERROR - 1242021 - (1) Syntax error near ['if'].

Thank you, Kevin

Tagged:

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