Ralph Kimball's The Data Warehouse Toolkit 2nd edition has a chapter on building All sorts of various data warehouse schemas. One is an Inventory Balance Snapshot. Im sure the design...