<div align="LEFT" dir="LTR">For Creating customize reports we need to know the data source and how to work the data source. Also access to the databases may influence your decision. To refreshing Excel reports, you must grant more extensive permissions to the data warehouse. </div>
<div align="LEFT" dir="LTR">Business reports that users share widely, that must be refreshed regularly, and that must be available on-demand, you may want to customize or create reports in SQL Server Reporting Services.</div>Team Foundation server has 3 data store which are:
<div class="separator" style="clear:both;text-align:center;"></div><ol type="A"><li>Team Foundation Server operational store</li><div align="LEFT" dir="LTR">It’s set of database which handle all data including source control, build reports, work item, test results so on .It consist of set of database including TFS_Configuration, individual team project collection’s database. It has adapter for pushing data into warehouse.By default the interval is 3600 seconds and it is configurable through controller service.</div><div align="LEFT" dir="LTR"> </div><div align="LEFT" dir="LTR"> <li>Team Foundation Server data warehouse</li>
<div align="LEFT" dir="LTR">TFS Warehouse is used for query and report’s. It collect data from data from operational data store periodically. Update from operation from operational server to warehouse is based on different event. When any event fire adapters has the responsibility for sending data to warehouse.It is also configurable to change the refreshment interval through WarehouseControlWebService. </div>
<div align="LEFT" dir="LTR"> <li>Team Foundation Server OLAP cube </li>Team Foundation Server OLAP cube gets data from warehouse on certain interval through a scheduled job .Data of cube can be used through verity of tools Microsoft Excel ,SQL report designer.
</div></div></ol>