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

Changing From Full to delta load

Could someone please help with this

i have used a Functional Module to extract data from R/3

i have created a new InfoCube and did a full load and everything is fine

There is NO ODS involved

i now want to change data loads from FULL to DELTAs

Can i do this without using an ODS and RECORDMODE - if so, how?

Thankyou

Pushpa

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 05:18 PM

    Hi Pushpa,

    Few options as i see.

    1. If you have a date field or numeric pointer in the underlying table which can be used as a delta enabled, you can have that field as the pointer and enable deltas.

    2. If it is a custom function module, you can handle the delta capabilities there.

    3. If there is any date field in your infopackage selection and you have 0CALDAY/0CALMONTH mapped in your transfer rules, you can go for a pseudo delta based on the OLAP Variable 0CALDAY or 0CALMONTH.

    Hope this helps.

    Thanks and Regards

    Subray Hegde

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 10:34 PM

    Hello Pushpa

    1. After full load you can do delta for cube not for ODS. To do a delta after full in ODS you need to mark the full load as repair as full request.

    So in your case it is possible

    The only thing you have to do it to identify the delta

    you may have numeric pointer..like document no.

    You may have date field..like 0calday....

    Define them in R/3 data source maintenance for delta and extract data

    Thanks

    Tripple k

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 07:40 AM

    HI Pushpa,

    For generic DS we need to maintain the generic delta. We can define in three ways.

    1.Calday

    2.Numeric Pinter

    3.Timestamp

    If we go for calday then there should a field (0calday). Which holds both created and changed the date of the record. We have 1 drawback in this we can only run the load only at the end of the day.

    Numeric Pointer will only fetches the changed records.

    Most of the time we preffer we go for timestamp.

    U will get these option in RSo2 in R/3

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

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.