Enter in the Setting Id: Run Interval Seconds and in the new Value the number of seconds (3600 is one hour) 5. Open the list of web services again with Foundation/Administration/v3.0/Warehouse Control 2. This can take some time when you have a large database.Click on Invoke to change the setting You can also choose to refresh the cube once. Select the Process Warehouse web service from the list 3. To check the status of the warehouse update, you can check the Get Processing Status webservice.For changing the caching settings of the reports see To change the interval, choose the Change Setting webservice 4.To change the interval follow the following steps 1. Open Internet Explorer and type Foundation/Administration/v3.0/Warehouse Control in the adress bar. You will see a new page where you can enter the setting and its new value.This article is designed to do a walk-through of viewing a TFS report using SQL Server Reporting Services (SSRS).For a video explanation and demo of this same material and other related TFS Reporting information, see the article on TFS Test Tools.The reports consume data from the TFSWarehouse database on the TFS server.So I looked there to make sure the warehouse was being updated.
Be aware that SSRS is caching the reports, which means that when the data might not be refreshed in the SSRS report as you expected.
This article supplements the MSDN documentation If you’ve used Microsoft® Visual Studio® Team Foundation Server, you may have seen reports and wished you could create your own custom reports. If you want to customize existing reports, you should read this article first, and then read the companion article .
Several years ago I volunteered to revise some of the standard reports for the Microsoft Solutions Framework (MSF) team at Microsoft.
Querying the [Work Item] table revealed that the warehouse tables were in fact not being updated.
The only sprints found in that table were the ones showing up in the drop down list in the report.