Skip to Content
avatar image
Former Member

Delta enable 0CO_OM_CCA_1

I read on a thread that you could delta enable the Plan data extractor 0CO_OM_CCA_1 by using an ODS object in between ? Can someone help me understand how to do that.

Will reward points for any suggestions or help.

Thanks

Richard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 17, 2006 at 05:28 PM

    Hi Richard,

    The ODS has an active table and a change log table. As a result of which whatever changes are retrieved in data loads there is a change log maintained for the same in the change log table. Moreover because of the reverse image concept, the same change records can be passed forward to an Infocube, thus providing the delta capability.

    For better understanding on the tables within an ODS refer to the below link

    http://help.sap.com/saphelp_nw04/helpdata/en/f9/45503c242b4a67e10000000a114084/frameset.htm

    For record updation in ods refer to below link

    http://help.sap.com/saphelp_nw04/helpdata/en/10/54853b175d214ee10000000a11402f/frameset.htm

    For delta processes refer below

    http://help.sap.com/saphelp_nw04/helpdata/en/84/81eb588fc211d4b2c90050da4c74dc/frameset.htm

    Hope it helps

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2006 at 05:19 PM

    Hi Richard,

    Well,to my understanding if an extractor is not delta enabled ,then rather than directly loading the infocube with all the full loads, we can have an ODS in place and can have the overwrite functionality,and can even write a Start Routine to check with the incoming data and the Active table of the ODS to eliminate the same records, being processed.

    Then we load the data from ODS to Infocube with delta mode.

    Hope it helps.

    Thanks,

    Krish

    *Assigning points is the best way to say thanks in SDN

    Add comment
    10|10000 characters needed characters exceeded