Understanding Dimensions

So far, we’ve addressed the underlying OLAP cube as a single star schema—that is, fact tables plus dimension tables. This is a bit of an oversimplification. Although it’s possible to base an OLAP cube on such a simple structure, in our experience business requirements and source data often introduce complexities. One of those complexities is the need for distinct sets of permissions or processing settings at the cube level. If this in an unavoidable case (and one that is justified by business requirements), you can create multiple OLAP cubes. Because this situation is common, we usually begin our cube design with dimensions and then proceed to measures. Our goal is always to create a single cube. If that is not practical, ...

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.