Chapter 5: The Value Chain

1
Adv. DBMS DW
Chapter 5 The Value Chain
Hachim Haddouti
2
The Value Chain

• Series of databases that represent the value
  chain of the product flow
• Value chain
• Demand side needs to satisfy customer s demand
• Supply side needs to manufcture producst

3

• The Demand Value Chain
• six databases (all steps of product flow)
• finished goods inventory
• manufacturing shipments to distribution center
• distribution center inventory
• distribution center depletions to retail stores
• retail store inventory
• retail store sales

4
The Demand Value Chain
Finished Goods Time, Product,
Warehouse Shipments to Distribution
Center Time, Product, Warehouse, Center,
Contract, Mode Distribution Center Time,
Product, Center Depletions to Retail
Stores Time, Product, Center, Store, Contract,
Mode
5
The Demand Value Chain cont.

• Physical products move sequentially through this
  sequence
• --gt May involve multiple different companies
• All 6 DBs share Product and Time dim
• The attraction of assembling a value chain of
  databases is that several can be combined in a
  single report by drilling across.
• --gt snapshot of the value chain, how the bulge
  of product moves from manufacturer to consumer

6
The Demand Value Chain cont.

• Design principle
• In order to support drill-across applications,
  all constraints on dimension attributes must
  evaluate to exactly the same set of dimensional
  entities from one database in the value chain to
  the next database in the value chain.
• a common dimension table shared by all fact
  tables
• special cases
• dimensions with reduced detail (Ch 16)
• eg, manufacturer has a finer detail than later
• derived dimensions that support aggregates (Ch
  13)
• precomputed sums to help specific queries

7

• Potential subdivisions in the value chain
• Transshipments -- shuffling materials before
  passing them on, eg. with multiple holding points
  in multiple plants.
• Breaking inventory steps -- unallocated to
  allocated
• Separating orders and shipments, returns
• multiple shipments can satisfy one order
• returns must be tracked carefully, with reasons
  (Return Reason, Disposition.in separate dim)

8

• The supply value chain
• Representing the manufacturing processraw
  materials converted to finished goods.
• Suplly-Side includes measurements of cont. Flow
  processes as well as the document-oriented
  processes seen on the Demand Side.
• different databases
• purchase orders
• deliveries
• materials inventory
• process monitoring
• bill of materials
• finished goods inventory
• manufacturing plans

9
The supply value chain
different databases cont.

• Purchase orders
• Time, Part, Supplier, Deal
• Deliveries
• Time, Part, Supplier, Plant, Mode, Deal
• Materials inventory
• Time, Part, Plant
• Process monitoring
• Time, Part, Process, Plant
• Bill of materials
• Time, Part, Product
• Finished goods inventory
• Time, Product, Warehouse
• Manufacturing plans
• Time, Product