Force the TFS warehouse to rebuild

The reporting warehouse for TFS is rebuild by default every hour. This is in normal situations accurate enough.

However, when you are testing how your modifications to your TFS artiface will be represented in the reports, you want to force to rebuild the TFS warehouse. You can achieve that by opening the SQL Server Management Studio, and then create a connection to your SSAS cube. Right click the cube and then Process the cube.

You can achieve the same with a webservice call to your TFS app tier. The web service is:

http://<MyTfsServer>:8080/warehouse/v1.0/warehousecontroller.asmx?op=Run