TFS Requirements Report Showing Incorrect Data

Question

I have an interesting problem with TFS reports. When I run QUERY: Team Queries-> Planning and Tracking-> Work Breakdown, I see the correct information, that is, I see the work items, etc. that are entered into TFS. However, when I run REPORT: Reports-> Project Management-> Overview of Requirements, I see the same PLUS data that is no longer in the system.

Important Information: * I am using TFS 2010 * When I initially created this project, I used the Microsoft Project plan to load work items. Before my team started using it, I decided to forget about the project and just use the web studio interface, so I used the "Delete all items" query to clear the database.

While pure work in all other cases, this report seems to hold on to these elements, and I would like to know if there is a way to fix this. Several weeks passed, and I ran the cube reports to find out if it is being updated (everything is being updated perfectly).

Does anyone know what is going on here?

Answer 1

I am not familiar with the query you are talking about, but if you delete work items, the removal may not be distributed to your warehouse (and then to the cube). If the TFSWorkItemTracking database has a relatively small number of WorkItems, it might be a good idea to rebuild your TFSWarehouse, which will then update your cube.

SetupWarehouse.exe, ​​ . , , . TFS, .

TFS 2008. , TFS 2010

, SetupWarehouse.exe TFS2010. , - > , " ". . . " ". - , . , , .

, , TFS Power Tools. TFPT "destroywi", ( ) TFS.

: http://msdn.microsoft.com/en-us/vstudio/bb980963