Rebuilding the TFS Warehouse for Excel reports

You can use Excel reports with Microsoft Test Manager as described here You need to have SQL server Analysis services turned on to make Excel reports work. The Excel gets data from the Analysis Services cube, which in turn gets data from the TFS Warehouse on a periodic basis. Since test results, test plan and…

1

Using Excel reports with Microsoft Test Manager to identify test state at a test plan level

From Microsoft Test Manager, it is possible to identify the state of test cases (pass, fail, blocked etc) for a particular test suite. You can just select the test suite on the left side and the right pane would show all test cases with their test status.                 Figure 1 – Selecting a test suite…

1