Need of Change log deletion for a DSO, when DTP delta Init with Active Tabl

[Former Member]

Hi,

Thanks for your time, please help me with the following

Scenario: I have Cube1 being updated from DSO1 with DTP delta, for quite some time. As per new requirement, I would need to create new data mart such that Cube2 gets updated from DSO1.

In order to Configure the delta, I am Considering Following options, please let me know, which one is right one.

Note: DSO1 is in Overwrite Mode.

Create one DTP with update Mode "Delta" , and "Active Table". I knew Delta Changes are captured in change log, but my understanding is, when you execute the DTP for the First time, it fetches the records from Active Table. And from 2nd Run onwards the very "same DTP" without "any changes" get the records from change log, even if we choose "Active Table".

is my understanding is Right?

Do I have to consider deleting the change log, because DSO1 is in Production from quite some time which is in Overwrite mode?

Do I have to create a DTP with Delta and Active Table, run the dtp Once(Init), then choose "Change Log for subsequent runs explicitly

please help me with these. I have reviewed many sap help articles and sdn threads but none of them were helpful. all of them explains, difference b/w active table and change log table, also gives scenarios like use a full DTP and then 2nd DTP with Delta without Data transfer. I am not looking for that kind of details.

Appreciate any help, Thanks again

Edited by: curious maven on Mar 28, 2011 8:35 AM

[Former Member · Accepted solution]

Hi,

The DSO1 is in production mode for quite sometime, which means there is a lot of data in the DSO1. Do you want all of this data to be loaded to your cube2 or you just want the latest requests from DSO1?

If you just want the latest requests from DSO1, then you can create a delta DTP from DSO1 -> Cube2 and set the Process mode in the execution tab to "No data transfer; delta status in source: fetched as processing mode" and then execute the DTP. When there is a new request in the DSO1, if the DTP between DSO1 and Cube2 is executed again with "Serial Extraction Mode", it will fetch the new records.

Hope this helps!

Regards,

Uma

[Former Member · Accepted solution]

Hi Uma,

Thanks for your response.

to your question, If I need to load all the data from DSO1 to Cube1, answer is NO. if you read my post once again,

Existing Flow is : DSO1 --> Cube1 (Means, Active Table and Change Logs of DSO1 already Filled Up)

Requirement is: DSO1 --> Cube2. (Need to Init the Delta, and Detlas going forward)

My Questions:

(1) Imagine, DSO1 has 10 requests, so we see resepctive data in Active Table as well as Change Log. As a matter of fact, Data is being updated to DSO1 in Overwrite Mode, so all the changes(10 requests equivalent) would be captured in Change Log, which in turn helpful / used when we do Delta from DSO1 to any Cube, in my case, it used to update to Cube1. As per new requirement, it needs to update to Cube2.

My assumption is, if I choose "Active table and Delta in Extraction Tab" in DTP, During First Run (Delta Init), Data would be fethed from Active table. And the 2nd Run Onwards, delta records would be fetehced from Change Log automatically, even if we don't change the selection from Active Table to Change Log.

Is My Assumption Right?,

in this process, Do I have to Delete Change Log

(2) Do I have to Explicitly change DTP setting from "Active Table to Change Log" Once Delta Init has been run with setting "Active table" inorder to get Deltas from DSO1 --> Cube2 ?

Appreciate your help

Edited by: curious maven on Mar 30, 2011 3:14 PM

Edited by: curious maven on Mar 30, 2011 3:29 PM

[nilesh_vakil · Accepted solution]

You are right first time the data for the cube will be taken from Active table of DSO only.

But when u run the delta after first load, system will automatically push the delta entries in Cube without chaning the DTP setting.

But if you want historical data into the Cube for reporting as of previous one, just mkae the following the setting

Tab : Extraction

Select option from Change log ( It will push all the entries in the change log)

Also check the option Get all new data by request by request

Hope this will solve your problem

Regharding DSO Change Log Deletion :

You can delete the change log theoratically if gets inserted into data target. But good practice is to delete the Change log more than 30 days old.

Edited by: Nilesh Vakil on Apr 1, 2011 11:21 AM

Edited by: Nilesh Vakil on Apr 1, 2011 11:35 AM

[Former Member · Accepted solution]

Hi,

Ok I got your question.

You don't have to delete the change log table or you don't have to change the DTP setting from Active table to Change Log table.

The change log table is used for retrieving delta data and records are picked up based on the 0RECORDMODE. When you have the extract from setting as Active table, the records with appropriate 0RECORDMODE value (value for Active records) are picked up.

Regards,

Uma

[Former Member · Accepted solution]

Thats Awesome,

That is what I need. Appreciate your help

[Former Member]

You can create a new Cube 'Cube2' and connect it to DSO 1 via transformations.

The DTP will take care of on its own once the setting in the DTP has been set to either full or delta and will not need initialization and the data will start flowing into this new Cube.

[Former Member]

Hi ,

Your DSO is in Overwrite mode it means DTP loading DSO will overwrite data .You will have data in DSO .

When you want to load it in cube then you will create a new Transformation from DSO to Cube and A DTP loading from DSO to cube .

so your flow will be like :

DataSource ->DTP1 to DSO ->DSO ->DTP2 from DSO to cube ->cube1

DataSource ->DTP1 to DSO ->DSO ->DTP2 from DSO to cube ->cube2

When you will load via DTP to cube 2 you will get all the records first time even if it is Delta.

Hope it will clear you doubts .

Regards,

Jaya

[Former Member]

Hi,

Please go thru this Wiki:

http://wiki.sdn.sap.com/wiki/display/BPX/Integratingexisting3.xflowwith7.0flowusingDTPfordeltaandfullandexploringtheDTP+world

Actually you dont have to intialize when you have a New Cube(Data Mart)

Just Create Transformations between DSO and Cube then---> When you create a New DTP will read all the delta from Infopak and you can continue to run Delta from there on.

@AK