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

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

hi Srinivas Neelam,

I forgot to mention that there is another field called "Extraction Mode" under the Extraction tab of the DTPs and all the values for this field is "Delta". Below are the data flow logic:

ZDSO2 -> ZDSO1 Extraction Mode is "Delta" and Change Log" under the section "Delta Init. Extraction From..." is checked.

ZDSO3 -> ZDSO1 Extraction Mode is "Delta" and "Active Table (Without Archive)" under the section "Delta Init. Extraction From..." is checked

ZDSO4 -> ZDSO1 Extraction Mode is "Delta" and "Active Table (Without Archive)" under the section "Delta Init. Extraction From..." is checked

We are confused that for 1st data flow DTP logic, the extraction mode is already set as "Delta", then why "Change Log" is checked again? Also what does it mean by other two data flow logic settings?

Thanks!

[mansi_dandavate · Accepted solution]

Hi,

THese settings only matter for a full DTP.

However for a delta DTP since its a delta, the setting only matters for the first request i.e. initialization.

The rest of the requests extract data from change log only.

[Former Member · Accepted solution]

hi mansi dandavate,

You day "for a delta DTP since its a delta, the setting only matters for the first request i.e. initialization.

The rest of the requests extract data from change log only."

Let's take 1st data flow logic to do the illustration, it's Delta extraction mode, then from what you say, the section "Delta Init. Extraction From..." settings only matter for the first request or initializaiton, but why 1st data flow "Change Log" is checked for Intialization?

ZDSO2 -> ZDSO1 Extraction Mode is "Delta" and Change Log" under the section "Delta Init. Extraction From..." is checked.

Thanks and Looking forward to hearing from you asap!

[mansi_dandavate · Accepted solution]

Hi,

In my project we have always used the option active table without archive for all Delta DTPs..

Thats the option we get by default.

I dont have any idea why have you changed the option to change log.

So in your case when the first delta is done data will be extracted from change log instead of active table.

You will have to test and see what impact does it make..

[mansi_dandavate]

Hi,

When you load data from DSO to InfoCube you have following options :

Active Table (with Archive)

The data is read from the active table and from the archive or from a near-line storage if one exists. You can choose this option even if there is no active data archiving process yet for the DataStore object.

Active Table (Without Archive)

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

Archive (Only Full Extraction)

The data is only read from the archive or from a near-line storage. Data is not extracted from the active table.

Change Log

The data is read from the change log of the DataStore object.

Also note that,the settings in the group frame Extraction From... or Delta Extraction From... of the DTP maintenance specify the source from which the data of the DTP is extracted. For a full DTP, these settings apply to all requests started by the DTP. For a delta DTP, the settings only apply to the first request (delta initialization), since because of the delta logic, the following requests must all be extracted from the change log.