How do I setup sub variable with double quotes using batch file and MaxL script?

Updating for an error in the calc script function using a sub var:

@NAME(&BusArea)


Good Luck!

Try passing the parameter as "'"value"'". That is quote-single quote-quote Value quote-single quote-quote.


I created a max script called var.msh to update a variable I created for the demo application.

Alter application 'demo' set variable 'test_var' $1;

And called the script like this:

msh var.msh "'"X"'";

This set the variable to the value "X".

Hi jjacks. What version of Essbase are you running your script against? When I run the same in version 7.1.3 (I know... ancient!!) my MaxL log confirms this:

MAXL> alter system set variable XTestVar "'Total'";

But the server shows Total with no quotes.

Like wise, when I use the same with the value "'"Total Company"'" , MaxL confirmed

MAXL> alter system set variable XTestVar "'Total";

And the server shows Total with no quotes.


OP: which version are you using as well?

I'm using Essbase MaxL Shell - Release 9.3.1 (ESB9.3.1.2.6B001).

Hi Shulman,

I am currently facing same situation.

I have to pass 9507 value to variable its dropping quotes.

alter database 'APP'.'DBS' set variable 'QLVMeasure' "'$4'";

were you able to resolve this. I am on 11.1.1.3.

Thanks in Advance.

Thanks guys its working

Alter database 'APP'.'DBS' set variable 'QLVMeasure' "\"$4\"";