Skip to Content
avatar image
Former Member

delta deleted

Hello,

I need to transfer data from a cube #1 in a cube #2 mode delta. And if the next time you boot in the request lacks a key value that was previously loaded into a cube #2, these values must be assigned zero (delete).

I think to use the following architecture,

KUB #1 -> DSO -> KUB #2

How can I arrange deletion of data in the target (cube #2) through 0recordmode?

I have to add a new key figure in the cube #2 - "delete flag"? But how to fill it?

Best Regards, Kuznetsov Pavel.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2014 at 09:01 AM

    Hi Kuznetsov,


    Record mode (0RECORDMODE) 'D' is used for deletion of a record. Only the key fields have to supplied.

    However, it might be that standard functionality could lead to same result. In the context of InfoCubes I think of the loading option "delete of overlapping request".


    Best regards,

    Sander


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Kuznetsov,


      It's a bit hard to have the full picture w/o knowing more details of your requirement. Generally speaking you probably have to build a transformation with ABAP logic where both source and target are the Intermediate DSO. This way you can analyze if deletions took place. Those deletions have to be uploaded to the Intermediate DSO with 0RECORDMODE = 'D' (key fields of the DSO are enough, other fields can be empty). This way the active table will show the right situation after activation and also will lead to a delta with deletions towards the second InfoCube.

      I would suggest to add a Characteristic to the Intermediate DSO, e.g. a timestamp of last loading. I don't know if your uploads are done based using a fixed time period (e.g. last calendar month). This will then also have to be taken into account. The records which do not have the latest timestamp, were not present anymore in the last upload and will have to be deleted.


      I hope that this approach makes sense.


      Best regards,

      Sander