Skip to Content
avatar image
Former Member

DTP Delta and Full Load...

Dear All,

I'm working with SAP BW 7.3 and I have a standard data flow, starting with DataSource, DSO and InfoCube. My process chain faced an error and for last week or so I could not fetch deltas. To remove the error I had deleted all records from InfoCube, since I had all requests available into DSO. Then I manually loaded Full Load from DSO to InfuCube. But next day when my process chain executed it brought all precious and new records again into InfoCube, as the delta was properly fetched into DSO but it did not come into InfoCube, as it was coming before. When I checked Active and Change Log tables of DSO these two had same number of records.

1. What could be the reason that delta DTP between DSO and InfoCube is not fetching only delta records, it was fetching deltas records before full load?

2. Have I made a mistake or missed any setting in DTP while executing full Load DTP between DSO and InfoCube?

3. What are these options for in Extraction Tab of DTP and when we use following options and why:

    i.   Active Table (with Archive)

    ii.  Acitve Table (Without)

    iii. Archive (Full Extraction only)

    iv. Change Log

I will appreciate your reply.

Many thanks!

Tariq Ashraf

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2014 at 06:42 AM

    Hi Tariq,

    After execution of full DTP, you need to execute delta DTP with "No Data Transfer; Delta status in source:Fetched"  option. Then next next delta it wont extract any requests which is gone in full load.

    Regards,

    PRK.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Tariq

      Concept of DTP are slightly different form Info Package. Example - Even if you have full load you can scheduled delta DTP. There are multiple documents with DTP in SDN which should give you insights about the settings to be maintained. (I cannot post the links here which is against SDN rules but you should get it easily)

      Thanks

      Abhishek Shanbhogue

  • avatar image
    Former Member
    Aug 22, 2014 at 07:28 AM

    Hi Tariq,

    Whenever you use full update DTP to load data from DSO to CUBE and you are using delta DTP to load delta's make sure that in DSO the datamart set. This datamart sign against each request indicates that the request is moved to futher object. Once you updated CUBE with Full update DTP just execute " No data Transfer " with Delta DTP. It will not bring your full data from DSO. Only delta will move into CUBE.

    If you are using Delta DTP to move the data from DSO to CUBE then you need not have to use this option.

    Please refer to the link for understanding options of DTP.

    http://scn.sap.com/docs/DOC-31781

    Hope this helps.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2014 at 07:12 AM

    Hi All,

    What are these options all about and why we use them in the DTP Extraction Tab:

         i.   Active Table(with Archive)

         ii.  Active Table(Without)

         iii. Archive (Full Extraction only)

         iv. Change Log

    Many thanks!

    Tariq Ashraf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tariq,

      Please check the below:

       

      Delta Init. Extraction from


      Active Table (with Archive)

      The data is read from the DSO active table and from the archived data.

      Active Table (Without Archive)
      The data is only read from the active table of a DSO. If there is data in the archive or in near-line storage at the time of extraction, this data is not extracted.

      Archive (Full Extraction Only)
      The data is only read from the archive data store. Data is not extracted from the active table.

      Change Log
      the data is read from the change log and not the active table of the DSO.

      Hope this answers your question. Let me know if any required.

      Regarsd

      Ramesh V

      pastedImage_8.png (88.6 kB)
  • avatar image
    Former Member
    Aug 22, 2014 at 07:33 AM

    Hello All,

    I'm further loading data from a Multi-Provider (based on two InfoCubes) to another InfoCube and I have deleted its all data and executed Full Load request DTP.

    1. Do I need to execute any delta DTP in above case?

    2. Do I need to do any other setting for above scenario?

    Many thanks!

    Tariq Ashraf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ramesh,

      In BI 7.3 we can load the data from Multiprovider also to any data container.

      However in previous versions we can load data from Infoset and other except Multiprovider.

      Regards,