Home > Uncategorized > MS BI Workshop #10 – Role-playing dimensions

MS BI Workshop #10 – Role-playing dimensions

Here is my notes #10.

On a very high level, dimensions provides the means to "slice and dice" data in a data warehouse. The primary function of dimensions is threefold: to provide filtering, grouping and labeling. It answers the where-clause questions for us. Look for word “by” in business documents.

Types of Dimensions

Conformed dimension

At the most basic level, conformed dimensions mean exactly the same thing with every possible fact table. An example of date dimension. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts.

Role-playing dimension

These dimensions are recycled for multiple applications within the same database.

In this example, the DimDate table serves as three different role, the order date, due date and the ship date.

image . it

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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

%d bloggers like this: