Slay Bad Data in Essbase • 53
5. e Refresh Variable VAR_CheckMaxLErr tests Validate.msh’s STDERR
output. If a Validate.err le with a le length greater than zero bytes is found,
a failure notice is written to the LoadStatus table through the Procedure
PROC_LogFailureStatus and the ValidateVariance table is truncated via the
Procedure PROC_TruncateVariance.
6. If Validate.err has a zero length, the at le output from Report Script
Validate.rep is imported to the table ValidateASOsamp through the Interface
INT_ImportValidateReport.
7. e Procedure PROC_FactVsEssbase compares the data values from Essbase to
a SQL-consolidated result set from the fact data. e dierence is written to the
table ValidationVariance. With luck and clean liv ...