There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Add variation to FactResellerSales, DueDateKey and ShipDateKey.
from Eric Hanson:
Here is an item on my wish list for improving AdventureWorksDW2008. Dbo.FactResellerSales only has sales for one day a month. It should have sales every day. This makes it much easier to write interesting queries. E.g. if you do
select distinct OrderDateKey
You now get
A similar issue exists DueDateKey and ShipDateKey.
Also, the delays from order/due/ship date are all fixed. Making them random (e.g. a bell curve with mean around a week) on a per-row basis would be cool.