Orders has OrderDate and ShipDate. A report must slice both roles independently at the same time. Which design is simplest?

Published
  1. Delete ShipDate
  2. Make both date columns text and concatenate them
  3. Use one date table with both relationships active
  4. Use separate order-date and ship-date dimensions

Comments — 0