Global "other" schema with UNITS_HISTORY_FACT
as the central fact table with a primary key consisting of four foreign keys: MONTH_ID
, ITEM_ID
, SHIP_TO_ID
, and CHANNEL_ID
. The Product dimension is shown with a separate table for each attribute.