Hyperion Planning (MOSC)

MOSC Banner

How to use a runtime variable inside a fix statement in MAXL script

edited May 25, 2018 5:00AM in Hyperion Planning (MOSC) 3 commentsAnswered

I am using a variable from a batch script to Maxl script. The variable is projectID. inside the MAXL I need to clear data for this project. here is the calc statement that I use to clear data:

execute calculation 'FIX("Account","Forecast","Input", $projectid) ClearData 2019 ; ENDFIX 'on 'AppName'.'DBName' .

   ERROR - 1012150 - Environment variable [projectid] doesn't exist..

when I run the script with this statement I get invalid Object. if put Quote around it like:

execute calculation 'FIX("Account","Forecast","Input", '$projectid') ClearData 2019 ; ENDFIX 'on 'AppName'.'DBName' .

it recognize the projectID but throws the syntax error:

MAXL> execute calculation 'FIX("Account","Forecast","Input", '002711') ClearData 2019 ; ENDFIX 'on 'AppName'.'DBName' ;

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