Where is the data for Build Coverage

Question

Hello,

I'm trying to build a report for Code Coverage Analysis. I've made the assumption that the data would be in TFSWarehouse.Buildcoverage.

When I query this table (or open it), I find no data, however when I run tests in Team edition & view Code coverage results window there is data showing code coverage analysis for the dll's chosen. Lots of it! Where is this data stored?

Many thanks for your help with this.

---

@nt

Answer 1

Hi,

The report also also use SQL Server Analysis Service as datasource .

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi

Answer 2

Hi Riuz,

I am running TFS basically out of the box. The only things that have been set up are those which would have been set up on installation. e.g. SharePoint

Do I need to set anything additional up (e.g. SQL Server Analysis Service) to have this report data?

Many thanks

---

@nt

Answer 3

Hi Ant,

Sorry, I did not understand what you said.

TFS  includes SQL Server Database, SQL Server Reporting Service and SQL Server Analysis Service. Reporting Service will use the data both in database(OLTP) and in Abalysis Service(OLAP).

So you need not to install SQL Server Analysis Service again.

If my understanding is not right, please feel free to tell me .

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi