Refresh TFS Warehouse, Cube and Reports on demand
By default, TFS will process it's Data Warehouse and Analysis Services Cube (and thus update the data for the reports) every 2 hours.
You can change the default frequency or manually invoke cube processing, if needed.
Be careful with changing it to lower values than every hour:
If you reduce the interval to less than the default of two hours (7200 seconds), processing of the data warehouse will consume server resources more frequently. Depending on the volume of data that your deployment has to process, you may want to reduce the interval to one hour (3600 seconds) or increase it to more than two hours. [Source: MSDN]
Alternatively you can use this small command line utility:
tfsrefreshwarehouse.exe /server:http://servername:8080/tfs [/full] [/status]
Using just the /status paramter returns useful information about cube processing:
(Note: The user needs to have the 'Administer Warehouse' permission in TFS)
Download the tool from here:
- You can specify "/status" to only query the time of the last warehouse/cube update.