How To: Rebuild the Team System Cube

There are times when you need to rebuild the Team System cube, the common scenarios are: whenever you move, restore, rename, or fail over the data-tier server.

The Team System cube is what the Reporting Services is using in order to create the Team System reports.

To perform these procedures, you must have the following permissions in SQL Server:

• You must be a member of the sysadmin security group for the database instance for Team Foundation and for the Analysis Services database instance of the Team System data warehouse.

• You must be a user of the TfsWarehouse relational database.

• You must be a member of the TFSEXECROLE database role.

Also, you must be a member of the Team Foundation Administrators security group, or the server-level Administer warehouse permission must be set to Allow.

Open a command line and change the directory to: Drive:%Program Files%\Microsoft Visual Studio 2008 Team Foundation Server\Tools

Now run is command in one line, make sure to change the bold  parameters to your parameters:

SetupWarehouse.exe -o –s DataTierServerName -d TFSWarehouse -c warehouseschema.xml -ra TFSReportServiceAccount -a TFSServiceAccount -mturl http://ApplicationTierServerName:8080

Have fun!!!