Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BI7: "Delta Init. Extraction From..." under DTP Extraction tab?

In BI7.0 environment, we've got a DSO called ZDSO1 and it's data comes from three other DSOs called ZDSO2, ZDSO3, and ZDSO4. In another word, ZDSO2, ZDSO3, and ZDSO4 fill data to their target ZDSO1, i.e.:

ZDSO2 -> ZDSO1

ZDSO3 -> ZDSO1

ZDSO4 -> ZDSO1

Check the three DTP settings of the three DSOs to load data to ZDSO1, find under the Extraction tab of the three, there is a section called "Delta Init. Extraction From...", under this section, there are four radio buttons:

Active Table (With Archive)

Active Table (Without Archive)

Archive (Full Extraction Only)

Change Log

For the DTP of ZDSO2 -> ZDSO1, the raido button of "Change Log" is checked, and for other two DTPs (from ZDSO3 and ZDSO4 to ZDSO1), the radio button of "Active Table (Without Archive)" are checked. Could any BI 7.0 expert illustrate how the section "Delta Init. Extraction From..." in DTP function and how the above radio button selections work?

Thanks!

Former Member
Former Member replied

Kevin,

DTP delta is request based delta. Same as loading from CUBE to other target.

But here we can choose from Active table or from change log table.

It depends on requirement. Depends on granularity and loading(Addition or overwite).

Its better to choose from Change log tables if data loading from DSO to target in addition mode at different aggregation levels. From active table only useful if entire data in source DSO getting refreshed every time.

Hope it Helps

Srini

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question