When I was studying data warehouse modeling, the first thing I came into contact with was the
order fact table, and the
date dimension tables.
order table will have
total_amount field for aggregate. (Sum the units sold, sum the total_sales_amount)
So I'm considering does a fact table always need to have a field for aggregate?
I'm asking this because in my data warehouse designing, I'm trying to create a schema like this.
Is this a real standard multidimensional data model that meets Kimball's methodology?