Slay Bad Data in Essbase - Developing Essbase Applications - page 68

-- $3 = Database name
-- $4 = Report name
Uses the following artifacts:
-- Report script: Validate.rep
-- Essbase substitution variables:
&ASOsamp_CurYear and
&ASOsamp_CurMonth
*/
/* Turn on timestamping */
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' ;

/* Run report */
export database $2.$3 using server report_file "$4" to data_file
"c:\\\\tempdir\\\\MaxL\\\\Data\\\\$4.txt" ;
iferror "RunReportFailed" ;

/* 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 "RunReportFailed" ;
/* Quit MaxL with a 50 error code */
exit 50 ;