Difference among Dimension, Dimension attribute and Facts

Question

So from what I've understand the best example of differences in (Dimension, Dimension Attribute, and Fact) would be something like this:

Dimensions - PRODUCT, ACCOUNT, CUSTOMER

Dimension attribute - ProductName, ProductNumber, CustomerName, CustomerNumber

Facts - usually measures. Dollar, Unit, Height

This is my attempt so it may be wrong. I want to hear your solutions?

Answer 1

A dimension is a collection of "reference information" about a measurable event. The Measurable event is a Fact.

So, if you have data say for example - Retail transactions, you would measure - transaction cost. So, your fact will have sales amount. Now, sales amount in itself does not make sense. You would need information like -

1. When was the sale done - Date dimension
2. Who made the transaction - Customer dimension
3. Which store was it made from - Store Dimension
4. What was brought - Product dimension

and so on. What information you want capture for each dimension is called the attributes. For Ex: A Customer dimension might have these attributes -

Customer Number
Customer Name
Customer Address
Customer Zip Code
Date Of birth
... and so on.