| • Step 1 |
Start Microsoft Excel.
|
| • Step 2 |
From the menu select Data > PivotTable and PivotChart Report.
|
| • Step 3 |
In the PivotTable and PivotChart wizard dialog select External Data Source and click the Next.
|
| • Step 4 |
Notice that the text next to the Get Data button indicates that no data fields have been retrieved at the moment.
|
| • Step 5 |
Click the Get Data button.
|
| • Step 6 |
Click the OLAP Cubes tab, Select and click OK.
|
| • Step 7 |
In Field 1 enter TeamSystem (or any name you want to give it). For field 2 select Microsoft OLE DB Provider for Analysis Services 9.0 and click Connect.
|
| • Step 8 |
Make sure Analysis server is selected and enter the server name in the Server field. For User ID enter TFSREPORTS and enter the designated TFSREPORTS password in the Password field. Click Next.
|
| • Step 9 |
Make sure TFSWarehouse is selected and click Finish.
|
| • Step 10 |
You should see that TFSWarehouse is displayed after the Connect button. Make sure that the Team System cube is selected. Check the Save my user ID and password checkbox and click OK.
|
| • Step 11 |
IN the Choose Data Source dialog click OK.
|
| • Step 12 |
In the PivotTable dialog click Finish.
|
| • Step 13 |
From the PivotTable Field List, double-click each of the following nodes in this order:
| • |
Team Project.Team Project |
| • |
Changeset |
| • |
Filename.File Path |
| • |
Lines Added |
| • |
Lines Modified |
| • |
Lines Deleted. | It is possible that not all required fields are present in you current PivotTable Field List. The necessary steps, to add the missing fields, are described in the How to add a Field to the Team System Cube post.
Close the PivotTable Field List window.
|
| • Step 14 |
Enjoy your great new PivotTable!
 |