Skip to Main Content
Professional Team Foundation Server
book

Professional Team Foundation Server

by Jean-Luc David, Erik Gunvaldson, Mickey Gousset
November 2006
Intermediate to advanced content levelIntermediate to advanced
521 pages
14h 16m
English
Wrox
Content preview from Professional Team Foundation Server

16.1. Reporting Services Architecture

SQL Server Reporting Services (SSRS) relies on the SQL Server 2005 database, SQL Server 2005 Analysis Services, and online analytical processing (OLAP) to mine project data. Figure 16-1 illustrates the overall architecture of Team System's data warehouse.

In Team System, metrics from every tool (testing tools, build, version control, and work items) are automatically pushed into several relational databases (operational stores), and then processed into an analysis cube (called TFSWarehouse). The default reports that ship with Team System tap into the warehouse to quickly generate graphs that provide a near-real-time view of the progress of your project.

NOTE

SQL Server Analysis Services is an OLAP database system.

Figure 16.1. Figure 16-1

16.1.1. Online Analytical Processing (OLAP)

Online analytical processing (OLAP) is a term that was coined by Dr. Edgar F. Codd, considered by many as the inventor of the relational database model. Dr. Codd came up with 12 rules that allow anyone to correctly identify any OLAP system. For example, the OLAP approach is designed to provide summarized data very quickly, is typically used in business or sales applications, and is an important component of business intelligence (BI).

You aren't restricted to use Microsoft tools to access an OLAP cube. Several third-party products can help you interact with them ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional Visual Studio® 2008

Professional Visual Studio® 2008

Nick Randolph, David Gardner

Publisher Resources

ISBN: 9780471919308Purchase book