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