Skip to Content
avatar image
Former Member

Transfering the Records from Changelog table to CUBE.

Hi Team,

I have wriiten a start routine for deleting the records from the active table of DSO

But,above the DSO,there is a cube is present.So,if i move the records from DSO to cube,all the entries(deleted entries also going to cube).

My changes shoud get reflected in Cube also.

So,if it possible to delete both records and changelog table??

if possible,can you please tell how it can be done.

Regards,

Varun Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 30, 2014 at 12:56 PM

    Hi Varun,

    Can you please share your coding in the Start Routine?

    You should not directly delete records from the Active table but rather use technical Characteristic 0RECORDMODE for this purpose. If you set 0RECORDMODE to 'D' (= delete), then you will delete the records the right way. You only have to supply the key fields.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Varun,

      I am afraid that it's not the complete source code. There is a part missing.

      Anyway, the method which I described (0RECORDMODE to 'D')  is a proven way and works perfectly together with the delta mechanism and reloads.

      In the coding you should write a statement like (e.g. after a particular condition is met for a particular record of the source package):

      SOURCE_PACKAGE-RECORDMODE = 'D'.

      Only the key fields have to be supplied; all other (non-key) fields can be initial.

      Best regards,

      Sander

  • avatar image
    Former Member
    Dec 30, 2014 at 01:01 PM

    Hi Varun,

    If the loads from DSO to Cue is delta then the data will be taken from Changelog table.

    So check the update mode and try to change to Selective Full (Full with filters) then the data will be extracted from active table.

    There is no method to do a selctive deltion only on Change Log Table. We have a process step to delete the entire data from Change Log.

    Regards,

    Bhaskar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhaskar,

      If i use full everytime,then it loses its efficiency rite?

      So,if it possible for delta update,and entry should fetch records as same as  active table to cube?

  • avatar image
    Former Member
    Dec 30, 2014 at 01:08 PM

    Hi Varun,

    Please see the link.

    Hope this helps.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 31, 2014 at 10:39 AM

    Hi Varun,

    Delta from Standard DSO will always takes the data from Change Log.

    The better way to delete the data from active table (which also reflects in change log) is changing the record mode to D.

    Rater than deleteing the data directly from Active table in the start routine. Make the Record Mode field to D for that particular record and activate the DSO.

    After activation the record will not be present in the active table and the new image will be created in the change log as well.

    Example Code :

    LOOP AT SOURCE_PACKAGE ASSIGNING <source_fields>.

      <source_fields>-recordmode = 'D'.

    ENDLOOP.

    Regards,

    Bhaskar

    Add comment
    10|10000 characters needed characters exceeded