Skip to Content
author's profile photo Former Member
Former Member

Master Data Delta

Hi can any one help how the delta happends in Master Data extraction.

Thanks a million in advance

redd

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 12:14 PM

    Basically it often happens the same way it happens in transactional data. You have a change date or time stamp or any kind of change log. The extractor then looks for the last timestamp extracted and extracts all the data with a timestamp greater than the last one.

    Is there any specific DataSource you want to know something about?

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 26, 2004 at 06:42 PM

    hi Dirk,

    Happy Christmas first.

    i want to know what are the settings we have to made when we extract master data using delta.

    Thanks a million in advance

    redd.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Call transaction RSO2. There you can create a data source for master data attributes e.g.

      IS_CLIENT

      This might be an attribute InfoSource for table T000.

      Note: The example is totally nonsense but it's just to show the technique. The advantage is that you can reproduce it in any system, R/3, CRM, BW or whatever.

      Now enter an application component (choose one by F4), maintain short, medium and long text (like 'Clients') and enter T000 as database table.

      Save and choose generic delta.

      For Fieldname choose a field that contains either a timestamp or a change date, in the case of t000 take the field CHANGEDATE. Now choose if you have a change date or a time stamp. According to the documentation a numeric pointer is only supported for SAP data sources so I'd leave it at that.

      Choose a security interval upper and lower border that seems sufficient (look at the F1 documentation, in our case I'd choose both as 1).

      Most of the time you won't store an additive delta in your tables so choose the upper radio button. This means that you need an ODS to get delta values into your cube.

      Best regards

      Dirk

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2004 at 02:14 PM

    Hi Dirk,

    Sorry for the late response as i was in vacation.

    Thanks a lot for the information.

    Regards,

    xys redd.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi xys redd,

      First of all I hope you have a happy new year.

      If you liked the answer feel free to assign some points. It's a way to say thanks.

      See: /people/mark.finnern/blog/2004/08/10/spread-the-love for directions.

      Click on the Yellow Star icon in each reply.

      You can give:

      1 - 10 pointer (solves problem, marks as answered)

      2 - 6 pointers (very helpful)

      Lots of 2 pointers (helpful)

      Best regards

      Dirk

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.