By default the data warehouse runs every hour.  Normally during your work this should be enough.  But there are moments you need the updated information directly.  To solve this you could force the data warehouse to update before the hour delay time is finished.

There are 2 ways of forcing:

1. By using the webservice locally on the TFS server.
2. By using SQL Management studio.

Using the webservice

1. Logon to the TFS server.
2. Open your browser
3. Browse to http://localhost:8080/Warehouse/v1.0/WarehouseController.asmx
4. Select the “Run” method 

The problem here is that you don’t have any identication when the job is done.  Except that you could check with “GetWarehouseStatus”.  If the result says it’s idle, then the job is finished.

Using the SQL Management Studio

1. Run the SQL Management Studio
2. Change the type to “Analysis Services”
3. Logon
4. In the Database node, look for the TFSWarehouse database
5. Right click on this database
6. Choose “Process” from the popup menu and follow the instructions in the popup windows

Using this method, you see the progress from this job.