Skip to Content
author's profile photo Former Member
Former Member

Selective Deletion and Delta Load

We have a BW system where a flat file is loaded (full) into an ODS and from there the data is loaded (delta) into an infocube.

Because of some external data problems, we had to use Selective Deletion in the InfoCube to delete all records regarding one of our organizational units and replace this with new records regarding the same org. unit using the normal upload procedure (first full to ODS, then delta to InfoCube).

The problem is that when performing the new upload, it seems like the load of the infocube does not recognize that there is new data concerning the org unit we deleted. The new data is present in the ODS, but the delta upload to the infocube does not see this as new data, even when we have deleted the old data in the infocube.

Are there some external tables where we need to delete some lines about the "old data" so that the delta upload functions correctly and adds the "new data" to the infocube?

Regards

Jon Christopher Knudsen

Oslo, Norway

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2004 at 06:37 PM

    Hi Jon,

    Its a bit of a mess. The ODS does the delta based on the change log it has and not based on what is there in the cube.

    The cleanest way is to redo the initial load from the ODS to the cube. Not sure whether it is possible in your situation.

    Add comment
    10|10000 characters needed characters exceeded