BusinessObjects Board

RecordMode on Extractors

Hi all,

I am trying to migrate a job from OpenHub to Data Services.

The downstream application makes use of the Recordmode from Openhub as it treats new records ‘N’ differently from updated records.

I followed the logic in this link:
http://wiki.scn.sap.com/wiki/display/EIM/Extractor+RecordMode

And wrote a function to add RECORDMODe to my extractor:

Return decode(  
($ODQ_CHANGEMODE = 'C' and $ODQ_ENTITYCNTR = '1') , 'N',
($ODQ_CHANGEMODE = 'U' and $ODQ_ENTITYCNTR = '-1'), 'X',
($ODQ_CHANGEMODE = 'U' and $ODQ_ENTITYCNTR = '1') , ' ',
($ODQ_CHANGEMODE = 'D' and $ODQ_ENTITYCNTR = '-1'), 'R',
($ODQ_CHANGEMODE = 'D' and $ODQ_ENTITYCNTR = '0') , 'D',
($ODQ_CHANGEMODE = 'U' and $ODQ_ENTITYCNTR = '0') , 'A', 'N' );

This has now been running for a week, however nothing has come through the extractor marked as ‘N’.

Openhub however does have records marked as ‘N’. Any idea why this might be ? either the logic above is wrong, or something is being does differently in OpenHub.

Help is appreciated !

Thanks.


Leigh Kennedy :australia: (BOB member since 2012-01-17)