One of the nice new features in TFS 2010 are the Excel Reports. They give you an easy to change view on top of the TFS warehouse. But you need to have the necessary rights before you can start playing with these Excel Reports.
- Viewing an Excel report:
- Member of the Team Foundation Valid Users security group.
- Edit an Excel report:
- Member of the TfsWarehouseDataReader security role in SQL. Server Analysis Services. (More info here)
- Contributor permissions in SharePoint Products for the team project.