O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

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

The Dimensional Model

The Data Warehouse layer is the heart of the business intelligence environment. In this layer, data from across the enterprise is presented as a unified whole and in a manner focused more on business processes and less on the source systems from which the data originates. The dimensional model has been widely embraced as the data model of choice within the Data Warehouse layer.

Within the dimensional model, business processes and events are presented as facts. Measurements associated with these facts, known as fact measures, provide a means of evaluating the represented business process or event.

To illustrate this concept, consider the fictional company Adventure Works Cycles, described in the sidebar "Welcome to Adventure ...

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