Skip to Content
avatar image
Former Member

Delta mode extraction

Hi BW SAPpiens,

I would like to understand the different delta mode extraction. I have found different values for the infoobjet 0recordmod but I don't understand the meaning of each case.

After-Image

X

Before-Image

A

Add

D

Supprimer (uniquement clé)

N

New-Image

R

Reverse-Image

Y

Update image (valeur résultant de la mise à jour)

Could you help me to specify the difference between these values ?

Thank's a lot

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 24, 2004 at 08:22 PM

    In BW, search for Element of 0RECORDMODE, ther you find the following technical details:

    ' ': The record delivers an after image.

    The status is tranferred after something is changed or added. You can update the record into an IncoCube only if the corresponding before image exists in the request.

    'X': The record delivers a before image

    The status is transferred before data is changed or deleted.

    All record attributes that can be aggregated have to be transferred with a reverse +/- sign. The reversal of the sign is carried out either by the extractor (default) or the Service API. In this case, the indicator 'Field is inverted in the cancelation field' must be set for the relevant extraction structure field in the DataSource.

    These records are ignored if the update is a non-additive update of an ODS object.

    The before image is complementary to the after image.

    'A': The record delivers an additive image.

    For attributes that can be aggregated, only the change is transferred. For attributes that cannot be aggregated, the status after a record has been changed or created is transferred. This record can replace an after image and a before image if there are no non-aggregation attributes or if these cannot be changed. You can update the record into an InfoCube without restriction, but this requires an additive update into an ODS Object.

    'D': The record has to be deleted.

    Only the key is transferred. This record (and its DataSource) can only be updated into an ODS Object.

    'R': The record delivers a reverse image.

    The content of this record is the same as the content of a before image. The only difference is with an ODS object update: Existing records with the same key are deleted.

    'N': The record delivers a new image.

    The content of this record is the same as for an after image without a before image. When a record is created, a new image is transferred instead of an after image.

    The new image is complementary to the reverse image.

    'Y': The record is an update image.

    This kind of record is used in the change log of an ODS object in order to save the value from the update. This is for a possible rollback and roll- forward for key figures with minimum or maximum aggregation. This record also has the update value for characteristics (in this case, it is the same as the after image). Null values are stored for key figures with totals aggregation. An update image is only required when the value from the update is smaller or larger than the before image for at least one key figure with minimum or maximum aggregation.

    Hope it helps

    GFV

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 25, 2004 at 09:53 AM

    Thank you Gianfranco for your kindness,

    The answer is very detailled.

    Have a good week end!

    Add comment
    10|10000 characters needed characters exceeded