3
Vote

Add variation to FactResellerSales, DueDateKey and ShipDateKey.

description

from Eric Hanson:
 
Hi David,
 
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
from dbo.FactResellerSales
 
You now get
 
OrderDateKey
20010701
20010801
20010901
20011001

20040531
20040601
 
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.
 
Thanks,
Eric

comments