Chapter 15. Basic OLAP

Andrew Brust

This chapter and the three that follow it focus heavily on Analysis Services, the core business intelligence (BI) component of Microsoft SQL Server 2008. SQL Server has had BI capabilities since the release of OLAP Services with SQL Server 7.0 in 1999. You might think that with such a significant history of BI components in the product, most SQL Server professionals would be well-versed in the technology.

However, as you probably know, this is not the case at all. For many SQL Server customers, the BI capabilities of the product have been lying dormant, not well understood, and somewhat shrouded in mystery. To be certain, the core SQL Server relational database product is separate from Analysis Services, and ...

Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.