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.
Regards,
Bill
