QA'ing a Data Warehouse

Have you ever been faced or are you faced with the problem of QA'ing a Data Warehouse?

We are currently looking into the feasibility of applying the Open Source Framework utPLSQL to automatically generate unit tests from the Data Warehouses Meta Data. I would be interested to hear from anyone who might be trying to do the same sort of thing or is perhaps interested in our results.