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 |
|
singh_vs
Starting Member
2 Posts |
 Posted - 2004-12-10 : 01:11:50
|
| Demo Events: This is a product demonstration (1 or more products) at a store on a certain date. So an event has a date, a store and 1 or more products. Sales: I have sales of all stores (POS – point of sale - data).This comprises product ID, price, date/time and store name/ID. To determine effectiveness of a demo – I need to know the date of the demo, the store it was held in and the products in the demo. I will sum the sales that fall for that particular date and store and products (1 or more). This gives me the sales of relevant products on demo date. Next I will sum average sales for same group of products for 2 weeks before demo date. Difference of these 2 will give me increase in sales due to demo. Step 3 gives me demo effectiveness of 1 demo. Eventually I need the demo effectiveness of a bunch of demos between user specified start date and end date. Goal: given a certain start and end date, find all demos falling within that range. For each demo, find increase in sales (for relevant store/products).We need the MDX and/or the cube design. Tables:Event – contains event Id, event date, event store IDEvent Details – contains event id and product id (1 to many mapping from event to product)Sales – contains product id, price, store ID and date |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-12-10 : 04:14:50
|
quote:
We need the MDX and/or the cube design.
How much are You paying ?rockmoose |
 |
|
|
singh_vs
Starting Member
2 Posts |
Posted - 2004-12-10 : 04:17:00
|
Paying? is this a paid site???quote:
Originally posted by rockmoose
quote:
We need the MDX and/or the cube design.
How much are You paying ?rockmoose
|
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-12-10 : 04:35:15
|
| No it's charity.What have You got so far ?And what problems have You run into that You cannot solve ?Or do You just want a pre-packed solution ?rockmoose |
|
|
|
|
|
|
find increase in sales