Skip to Content
0
Former Member
Sep 29, 2005 at 11:21 PM

Adding CALWEEK to extraction between ODS and CUBE

126 Views

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?