建立变量
其中：应用名变量来源sql（也可手工录入变量）
select substr(t.ext_name, 0, instr(t.ext_name, ‘.’) – 1) ——主资料档案库
from snp_pschema t
where t.i_pschema =
(select t.i_pschema
from snp_pschema_cont t
where t.i_context =
(select t.i_context
from snp_context t
where t.context_name = ‘<%=odiRef.getContext(“CTX_NAME”)%>’)
and t.i_lschema =
(select t.i_lschema
from snp_lschema t
where t.lschema_name = ‘****’)) ——该应用逻辑方案
执行命令：
./setvar.sh “#p_app_name” “BUDYEAR” “#varB_01_BUDYEAR”
./setvar.sh “#p_app_name” “PREBYEAR” “#varB_02_PREBYEAR”
./setvar.sh “#p_app_name” “ACTMONTH” “#varB_03_ACTMONTH”
./setvar.sh “#p_app_name” “BUDMONTH” “#varB_04_BUDMONTH”
./setvar.sh “#p_app_name” “BUDSCE” “#varB_05_BUDSCE”
./setvar.sh “#p_app_name” “BUDVER” “#varB_06_BUDVER”
./setvar.sh “#p_app_name” “BUDREA” “#varB_07_BUDREA”
./setvar.sh “#p_app_name” “PREBUD” “#varB_08_PREBUD”
./setvar.sh “#p_app_name” “PREBVER” “#varB_09_PREBVER”
./setvar.sh “#p_app_name” “LASTBUD” “#varB_10_LASTBUD”
./setvar.sh “#p_app_name” “LASTBVER” “#varB_11_LASTBVER”
setvar.sh 如下:
echo “login admin password on IP;” > /Oracle/Middleware/user_projects/epmsystem2/EssbaseServer/essbaseserver1/bin/setvar.mxl
echo “alter application ‘”$1″‘ set variable ‘”$2″‘ ‘\””$3″\”‘;” >> /Oracle/Middleware/user_projects/epmsystem2/EssbaseServer/essbaseserver1/bin/setvar.mxl
echo “logout;” >>/Oracle/Middleware/user_projects/epmsystem2/EssbaseServer/essbaseserver1/bin/setvar.mxl
cd /Oracle/Middleware/user_projects/epmsystem2/EssbaseServer/essbaseserver1/bin
./startMaxl.sh setvar.mxl
其中，setvar.mxl如下：
login admin password on IP;
alter application ‘****’ set variable ‘****’ ‘”****”‘;
logout;