I have an ODS that contains up-to-date data from some of the LIS extractors. We store the status of the data in a cube on a weekly basis (a so called snapshot) for historic reporting. Therefore, I must do a full dataload from the ODS to the CUBE.
For internal reasons we now want to be able to do a preliminary load on friday and a definitive load on monday. The load on monday should remove the load from friday automatically.
The problem that I experience is that in the CUBE there is no selection that shows me the weeknumber. Therefore automatic removal of the preliminary load is difficult.
Any ideas?