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 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.
