Not A homework assignment I just would like some help. Let give more details.
Hardware and operating system:
AMD Opteron 848 server running Windows Server 2003 SP1.
I need to set a variable in the batch so the users can change them in one place each month. The essmsh command starts the Essbase interface in interactive mode. The variables I'm trying to set need to update in CopySPS.txt prior to the essmsh line running. In CopySPS.txt they are set again so that Essbase can save them as user defined variables which are then used in calculation scripts.
***************BATCH SCRIPT**************************************
Set clearscen = Actual\\Forecast_2007
Set ClearStart = May
essmsh E:\Hyperion\HypData\EssAdmin\SPS\CopySPS.txt
*****************************************************************
***************************COpySPS.txt******************************
/* pdate the specified variable value. !!(SV_OptA_1, SV_OptA_2, SV_OptA_3, No Change)!!*/
alter database GL.GL set variable "clearscen" "Actual\\Forecast_2007";
alter database GL.GL set variable "clearstart" "May";
********************************************************************