Database Reference
In-Depth Information
set timestamp on ;
/* Define STDOUT and STDERR outputs */
spool stdout on to "c:\\\\Tempdir\\\\MaxL\\\\Logs\\\\$1.log" ;
iferror "BadLogFile" ;
spool stderr on to "c:\\\\Tempdir\\\\MaxL\\\\Logs\\\\$1.err" ;
iferror "BadErrorFile" ;
/* Log in to Essbase */
login admin epmtestdrive on metavero ;
iferror 'BadLogin' ;
/* only supervisors and developers may connect */
alter application $2 disable connects ;
iferror "CouldNotDisable" ;
/* Load dimension */
import database $2.$3 dimensions connect as 'hypsql' identified by
'hypsql' using server rules_file 'hDynSQL' on error write to
"c:\\\\Tempdir\\\\MaxL\\\\Logs\\\\hDynSQL.err" ;
iferror "DimLoadFailed" ;
/*
Quit MaxL without a predefined error code */
exit ;
/* Create label for login errors */
define label "BadLogin" ;
/* Quit MaxL with a 10 error code */
exit 10 ;
/* Create label for log file errors */
define label "BadLogFile" ;
/* Quit MaxL with a 20 error code */
exit 20 ;
/* Create label for error file errors */
define label "BadErrorFile" ;
/* Quit MaxL with a 30 error code */
exit 30 ;
/* Create label for disable connects errors */
define label "CouldNotDisable" ;
/* Quit MaxL with a 40 error code */
exit 40 ;
/* Create label for dimension load errors */
define label "DimLoadFailed" ;
/* Make sure that connections are enabled */
alter application Sample enable connects ;
/* Quit MaxL with a 50 error code */
exit 50 ;
/* Create label for enable connects errors */
define label "CouldNotEnable" ;
/* Quit MaxL with a 60 error code */
exit 60 ;
2.6.2.2.2 LoadData.msh
OS_MaxLDimLoad Command line
cmd /c C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\
EssbaseClient\bin\startMaxl.cmd c:\tempdir\MaxL\scripts\#VAR_
MaxLScriptName.msh #VAR_MaxLScriptName #VAR_AppName #VAR_DbName
Purpose—
Load the current month's data to ASosamp.Sample.
Code
