...
- Reporting system generates correct results. Numbers from reports match queries to database, expected results.
- The reporting system performs well under load when extracting data.
- The reporting system performs well under load generating analyzed/computed results.
- Reporting system is usable for Mifos users. Data warehouse is intuitive and documented.
- Summary results are accurate
- Can drill down from summary results to accurate information? (Question: are cubes are a requirement?)
- Test error situations, verify accurate notification happens
- Audit, error logging occurs
- Secure access to reports
...
The database test should be a SQL query to confirm the direct table query gives expected resultresults, e.g. selecting loans in arrears amount for a given branch. Steps include determining a finite test case, developing the proper query, then using DBUnit or a similar tool to validate query results against the Mifos database.
...