Skip to Content
author's profile photo
Former Member

Adding CALWEEK to extraction between ODS and CUBE

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 30, 2005 at 03:46 AM

    I think you can delete the Friday Request depending on the date of the Request (SY-datum - 3)and not by weeknumber. Because you are deleting on monday and reloading on Monday.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 30, 2005 at 04:36 AM

    Hi,

    You can delete the previous request.

    See here an example:

    delete-request-older-then-eg-10-days

    Though, it is for a cube, the procedure for an ODS is the same.

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded

    • I would rather not mix up with nearly simultaneous updating and deleting records in the cube. For me, it's better to create a separate program (SE38) with this code and schedule its execution periodically, before second updating, say, on Sunday.

      Best regards,

      Eugene

  • author's profile photo
    Former Member
    Sep 30, 2005 at 06:10 AM

    Hi,

    As given in the code

    Put the condition before the function module where it has been put as comment * perform check if request older than 10 days

    IF (SYS-DATUM - TS ) > 2

    ....

    Sachin K

    Add comment
    10|10000 characters needed characters exceeded