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

Chapter 1 Quick Reference

This

Means this

Dimensional model

The logical data model used within the Data Warehouse layer, which is focused more on business processes and less on the source systems from which the data originates. The dimensional model contains both dimension and fact information.

Dimension

Represents a set of related attributes that can be used to analyze data in the dimensional model. For example, the Adventure Works model contains a Product dimension, which enables analysis of data by product attributes.

Attribute

A descriptive characteristic included in a dimension. For example, in the Adventure Works model the Product dimension contains Product, Category, and Subcategory attributes.

Fact

Representation of a business process or event ...

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