Chapter 5. Logical OLAP Design Concepts for Architects

Correctly modeled and implemented OLAP cubes are the core of any Microsoft SQL Server 2008 business intelligence (BI) project. The most successful projects have a solid foundation of appropriate logical modeling prior to the start of developing cubes using SQL Server Analysis Services (SSAS). Effective OLAP modeling can be quite tricky to master, particularly if you’ve spent years working with relational databases. The reason for this is that proper OLAP modeling is often the exact opposite of what you had been using in OLTP modeling. We’ve seen over and over that unlearning old habits can be quite challenging. One example of how OLAP modeling is the opposite of OLTP modeling is the deliberate ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.