Some helpful administrative operations

Since shipping TFS 2005, I’ve answered several questions from customers on how to perform various administrative operations on the TFS warehouse.  I thought that I would take a moment to describe some of the most common operations that a user may need to perform at some point.  For each administrative operation, I describe the minimum permissions you will need to perform the operation and the list of steps that you will need to run.  The steps below are written for TFS 2008, but also will be very similar for those still using TFS 2005.  If you need help performing an operation not on this list, let me know.

How to force an update of the TFS Data Warehouse and OLAP Cube

Performing this action will trigger the TFS Warehouse adapters to update Relational Data Warehouse and OLAP cube.  This includes performing any necessary schema changes along with processing the OLAP cube.

1.       Ensure you have the necessary permissions.

a.       To invoke methods on the WarehouseController web service, you will need to have ‘Administer warehouse’ permission in TFS.  To view or grant this permission:

                                                                          i.      Connect to TFS from Team Explorer

                                                                        ii.      Right click on the TFS server name and select, “Team Foundation Server Settings -> Security…”

                                                                      iii.      Select the appropriate user or group from the “Users and Groups” list box in the top portion of the screen