Data Quality and Cube Output

[minotaur77]

I am working a new project where the goal is to verify that a cube was built properly and that the data matches the source data in the database.  My approach was going to be as follows:

• Create report studio report off of cube, listing all of the measure for the cube for the current day, previous day, current week, previous week, etc...
• Programatically run the report using the SDK.
• Screen scrape the data values from the report output.
• Run stored procs against the database to get the values straight from the source.
• Compare the output

My questions are:

• Do you think that approach is effective/will work?
• Does anyone have a good screen scraping example from the html ouput of a report?  I saw a reference to a screen scraping example in another thread, but I could not find the source.

Thanks,
Matt