Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chadmat
The Chadinator
1974 Posts |
 Posted - 2002-05-17 : 14:39:24
|
| I have the following cube structure: Dimensions:Product (PID, DeptGrp, Dept, ProductCode)Store (SID, Region, StoreNo, Register)(Should probably be called register but oh well)Time(TID, Date, Year, Quarter, Month, Day) Fact Table:ExtendedSellPricetransactionID (Which is rolled up as distinct count, not summed) (Also IDs for each Dimension) Pretty simple cube. However, the customer would like to know, for a given product, what were the top selling products that sold with that product. (A transaction in this environment is a customer checking out, so they may have 20 items, or 1 item it doesn’t matter, it is all 1 transaction). So if the product is ‘Gallon of Milk’ What were the other products that sold most often with a ‘Gallon of Milk’? How can I get this info. I don’t think it is possible with the current cube structure, but I can’t even think of how I could change the cube to get the info? If you have any Ideas, please help. Thanks-Chad |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-05-17 : 17:53:06
|
| Search MSDN for diapers and beer. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-19 : 15:27:11
|
Thanks AF,I actually found the Basket analysis paper just before checking out your post.  -Chad |
|
|
|
|
|
|
|
|
AS Query help