Andyblg's Blog

July 20, 2009

Facts and Dimensions in the OLAP solution

Filed under: OLAP — andyblg @ 23:48
Tags: ,

Logical Analysis Solution Architecture


Facts are predominantly numeric measurements, such as price or quantity. Facts form the basis of calculations, and you often aggregate them for members of a dimension.


Dimensions form the contexts for the facts, and provide the axes of the cubes in the OLAP solution. For example, you could create a Product dimension and a Store dimension. A typical query might retrieve the total quantity of units of each product that have been sold in each store.

Most OLAP solutions include a Time dimension, which has particular characteristics. Weeks do not fit neatly into months or years, leap years have an extra day, and, in countries with daylight saving time, some days have more or fewer hours than those in countries without daylight saving time.

© Microsoft Corporation

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at

%d bloggers like this: