I'm trying to extract out of SAP. I have two date fields in my table. One is 'Snapshot week' and the other is 'Calendar Week'
For one Snapshot week, I have historical forecasts (-1, -2, -3 and so on) and then I have future forecasts where (1,2,3,4 and so on)
So if my snapshot week was 9/1/2014, the historical forecast would include 8/25, 8/18, 8/11, 8/4 and so on
and the future forecast would have 9/1/, 9/15, 9/22, 9/29 and so on.
I want to limit the load so that it only brings in current snapshot week and 10 weeks of historical forecast data. This is what I have so far but it doesn't bring in any historical forecast data....so any idea on how to bring in the historical 12 weeks of forecast data?
SQL Select * from SAP_Table
Where /[Snapshot Week] = 201439;
STORE * FROM SAP_TABLE INTO $(vRootPath)\Data\QVDs\Forecast.QVD;