Hi

I have just implemented automatic builds which all seem to work fine, but when I run the Build Report I get no data. The report displays the follwowing message at the top of the report:

Report Generated: 20/09/2006 14:03:35 by BRINKSEMEA\tylerp; Last Warehouse Update: 13/09/2006 15:43:05

The builds were completed on 19/9/2006 but the Last Warehouse Update was completed on 13/9/2006. Do you know how I can update the warehouse?

You can process the warehouse from the Application Tier (AT) using a web service at:

http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx

1) Execute GetWarehouseStatus - this should return Idle.
2) Execute Run - this should return true.
3) Execute GetWarehouseStatus again - this should the current warehouse status (i.e. Processing Adapters, Processing OLAP). Poll this method until it returns Idle.

If the warehouse was not processed check the eventvwr (on AT) for errors.

Also note that the reports themselves will be cached. To disable report caching:
Browse to the Report
http://localhost/Reports
Select Project Folder, Select Report

Execute the report and select the "Properties" tab (near the top).
Select "Execution" from the menu on the left
Select "Do not cache temporary copies of this report" and Apply

You may want to reenable caching after you have verified everything is working.

Mnay thanks for this Nick, but I still have the problem. I do however have an error in the event viewer which I think is the problem. I have posted another entry for this as I do not seem to be able to find a solution.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=745648&SiteID=1