O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required