TFS & Visual Studio ALM – by Neno Loje

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:

Important

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:

Syntax/Usage:

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:

• For use with TFS 2010: TfsRefreshWarehouse.exe (.ZIP)
• For use with TFS 2012: TfsRefreshWarehouse.exe (.ZIP)
• For use with TFS 2013: TfsRefreshWarehouse.exe (.ZIP)

Update:

• You can specify "/status" to only query the time of the last warehouse/cube update.

–Neno