Skip to Content
author's profile photo
Former Member

Loading delta data to more objects

Hello BW experts,

Does anyone have experience in loading delta information to more data target?

My situation is the following:

I’m running delta on sales-orders-header + sales-order-item. When I load the delta information directly to my cube everything works fine (No duplicated data is loaded)

At the moment I only have one cube, but it will be more in the future.

Now I want to introduce an ODS layer to be able to prepare my BW for future changes in reporting requirements. I will keep all original data from the datasource in the ODS and apply update rules/transformation only to the cube(s).

I then have 2 options, but which one should I use:

1) Load data (from the delta queue) to the ODS and to the cube(s) in parallel (same infopackage)

2) Load data (from the delta queue) to the ODS first, and then from the ODS to the different cubes

If option 2 is recommended how do I identify the new records in the ODS (just arrived from the delta queue) to be loaded to the cube(s) so I don't get duplicated data in the cube(s)?

Any suggestions are appreciated.

Kind regards, Torben

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 30, 2005 at 10:40 AM

    Hi Torben,

    In case 2) you'll need to do init for the cubes, after that ODS will recognize new records for cubes during delta load.

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded

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

    Hallo Toben

    Once you do an init, then the system automatically will recognize which records are new or changed. (Change log table)

    Option two is better and you can manage to load different DataTargets in parallel. if you wan to filter, you can do it by Start Routine.

    Also have a look at ODS:

    http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

    Mike

    Add comment
    10|10000 characters needed characters exceeded