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

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

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