TFSWarehouse Cube Corruption

Ever got your TFSWarehouse Cube corrupted?

One of the reasons I got that corruption was due to machine failure that corrupted some of the cube's XML files, I spent quite some time trying to figure out the problem and how to solve it, but luckily I got to fix it easily in 4 steps.

1. Open SQL Management and Stop the TFS Analysis Service on the TFS Data Tier.
2. Go to "C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data" on the TFS Data Tier, and delete the folder TFSWarehouse.0.db and the XML file TFSWarehouse.0.db.xml
3. Run the following command on the TFS Data Tier to rebuild the cube, it can be found in "C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Tools"SetupWarehouse -o -s TFSServer -d TFSWarehouse -c warehouseschema.xml -a TFSServiceAccount -ra TFSReportsAccount -mturl http://TFSServer:8080
4. Start the TFS Analysis Service on the TFS Data Tier and Process the cube to get back on track.

That's all you need to do. Hope that will help ...