Use Case Progress Excel Report (GovDev)

You can use the Use Case Progress Excel Report to track the rate at which the team is implementing use cases. This report shows the distribution of active, resolved, and closed use cases over time. For information about how to access this report, see Excel Reports (GovDev) .

NoteNote

You can view the Use Case Progress Excel Report from the Progress dashboard. You can access this dashboard only if your team project portal has been enabled and is provisioned to use Microsoft Office SharePoint Server 2007. For more information, see Access a Team Project Portal and Process Guidance.

Required Permissions

To view the report, you must be assigned or belong to a group that has been assigned the Read permissions in SharePoint Products for the team project.

To modify or customize the report, you must be a member of the TfsWarehouseDataReaders security role in SQL Server Analysis Services. You must also be assigned or belong to a group that has been assigned the Members permissions in SharePoint Products for the team project. For more information, see Grant Access to the Databases of the Data Warehouse for Visual Studio ALM and Managing Permissions.

Data in the Report

You can use the User Case Progress Report to understand how well the team is completing the use cases that it defined for an iteration or release. This report is based on a PivotChart report that shows the last four weeks of data that was captured for use cases and that is stored in the data warehouse.

Example Use Case Progress Excel Report

Required Activities for Tracking Use Cases

For the Use Case Progress Excel Report to be useful and accurate, the team must perform the following activities:

  • define use cases.

  • Update the State of each use case as it transitions from Active to Resolved to Closed.

  • (optional) Specify the Iteration path, Area path, or both for each use case if you want to filter by those fields.

Interpreting the Report

You should expect the Use Case Progress Excel Report to vary based on where you are in your product development cycle. Early iterations should show a gradual increase in the number of active use cases. Iterations that are near the end of a product cycle should show a wide band of resolved and closed use cases.

You can review the chart to determine the team's progress over time or during an iteration. Specifically, you can determine how much progress the team is making toward resolving and closing use cases.

Updating and Customizing the Report

See Also