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