Hi all,
I just add a bug in my project. But when I launch the "Bug Rate" report, I cannot see this happening. Is there any synchronization design in the reporting feature? Or, how can I see the data in the report in a synchronized way?
Thanks,
Leon
The data source of the reports is a warehouse. You won't see any change until the warehouse is rebuilt. The warehouse is rebuilt on a schedule determined by the administrator.
You can see the date the warehouse was last built by checking the top of the report.
To add on to Doug's post. The default latency for the data contained in the reports is 1 hour as the adapters run every hour to pump data from the relational databases to the Data Warehouse and therefore include all the changes that occured within the last hour. Once this process ends, the cube is rebuilt on top of the warehouse and the reports use the cube as the datasource for the data contained in the report.
Thanks,
Othmane
Also you can manually process the warehouse via the WarehouseController web service on the application tier. From the app tier
http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx
Invoke Run to manually process the warehouse. When GetWarehouseStatus returns Idle the warehouse processing is complete.
Reports are, by default, cached. If they are cached before processing the warehouse you will not see an updated report after processing until the cache expires. This page
http://msdn2.microsoft.com/en-us/library/ms157447(SQL.90).aspx
describes how to modify the cache expiration for a report.
Just use this URL on the TFS server:
http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx?op=ChangeSetting
And then type in: RunIntervalSeconds for the SettingID and whatever interval you desire (in seconds).
HTH
Kevin.
The Warehouse is not refreshing correctly the information, and reports show always old information.
I correct this, eliiminating the Report cache in all reports.
1.- Go to "http://<servername>/Reports"
2.- Go to the Directory of your TFS project.
3.- Enable the Detail View
3.- Click on the Properties for a report.
4.- Go to the the Execution option.
5.- Select the option Do not cache temporary copies of this report and click Apply
You can find more information here:
http://msdn2.microsoft.com/en-US/library/ms244674.aspx
I hope this can help.
