...
This is (probably) a temporary wiki page showing details of manual testing of Data Warehouse 1.0. Attached is the mifos 1.6.1 database backup (mifos_dw_etl_test_dataset.zip) which has the test data used during ETL testing. This page gives some idea of what's involved in the ETL job that moves data from mifos to the data warehouse. The actual Pentaho Data Integration job (CreateDataWarehouse.kjb) is in the business intelligence git repository (git://mifos.git.sourceforge.net / mifos/bi). Manual testing was by query inspection and running against some standard reports (Loan Officer Detailed Report, MFI Progress Report, Due vs Collect Branch Report and Due vs Collected Loan Officer Report).
The Data Warehouse ETL job should...
...