68 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
-- $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" ...