Labels:text | screenshot | font OCR: Product Sales dimension table fact table with LEVEL time dimension table time_key product_key product key LEVEL has time dimension table store_key SKU_description the values: promo_key SKU_number Base time dimension table qty_sold package size Brand. dollars sold brand dollars cost Category, subcategory and so on category department package_type Gand many more FIGURE 2 A typical dimensional data warehouse show- ing a dimension with the LEVEL field re- quired for embedded aggregates.
