How to query a price using Set Analysis or other approach?
Hi Guys!
I have this concern, since I don't have slow changing dimension of data, what I have is only a historical data where it only add new record whenever the price changes or have promotions. Please find the sample data below:
Item
Price
Start Date
End Date
A
100
10/1/2014
10/31/2014
A
150
9/1/2014
A
170
8/1/2013
A
200
1/1/2013
NOTE: Record with END DATE is promotional price, so when end date is no longer current or not equal to current date, then use the previous record.
Find below the Q&A:
Q&A:
1. Q: What is the price of Item A on 9/10/2014?
A: 150
2. Q: What is the price of Item A on 10/15/2014?
A: 100
3. Q: What is the price of Item A on 11/1/2014?
A: 150
Could values/answers above could be done using set analysis? Or should I do other approach? Please let me know, your help is much appreciated.
