Delta Enabling In OSD_C05

[Former Member]

Hi ,

I Have Done LO Extraction beased on 2LIS_11_VAHDR , 2LIS_11_VAITM. The data was extracted to cube .

My set up table has 1 day data .

I did 'Init Delta Without Data Tranfer ' First . Then Full Update . Now i got that 1 day data into My cube .

Now i need to get the Deltas from that day . I donot know how to look the delta data .

My Extractor in LBWE is set to V3 Unserialised . I didnt set Other .

I need steps to enable Delta records fetching that automtically come to my cube .

Regards

Shiba

[Former Member · Accepted solution]

Hi,

You could've done a delta init with datatransfer and then set the delta.

For LO datasources the delta method should be queued delta.

Look at the weblogs below for LO Extractions :

/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

Cheers,

Kedar

[RenjithKumar]

Hi Vidya ,

Thanks , Can you tell me how can i schedule a collective run ...

I think your steps has to followed after scheduling collectuive run .

Before doing anything I checked in RSA7 there was entries for VAHDR , VAITM .

Shiba

[Former Member]

Hi Renjith,

To Schedule the Collective Job:

Transaction LBWE --> Select your Application Component. Select Job control Tab. Maintain Start and Print Parameters. Schecule the Job.

This would bring the left out delta records from Update table to RSA7.

Schedule Delta in BW.

Hope its clear now...

Regards,

Vidhya

[Former Member]

Hi ,

I have used ' V3 Unserialixed Delta ' in LBWE of R3 side , And i have done

' Init Delta Without Data Transfer ' .

' Done Full Update '.

'Now if i try to change the update method to Qued delta in LBWE I get the

following error .

<b>CHANGE OF UPDATE MODE NOT POSSIBLE DUE TO OPEN V3 UPDATE --> LONG RUN </b>

The error details is

You are not allowed to change the update mode for application 11 from V3 to another method. This is because there are still V3 update entries for update module MCEX_UPDATE_11 that have not been processed yet.

How to make this Update to Queued Delta , i think if i make this as queued detla then delta records will come if i make delta in Info Package .

Regards

Shiba

[Former Member]

Hi Shiba,

The error "CHANGE OF UPDATE MODE NOT POSSIBLE DUE TO OPEN V3 UPDATE --> LONG RUN" is because of open V3 in your Update Table.

To solve this issue, execute a Collective run in R/3. Then schedule a Delta in BW. This way you will not miss any delta records. After doing this you can change the update mode to Queued Delta if you need.

Steps to be followed:

1. Transaction LBWE --> Select your Application Component. Select Job control Tab. Maintain Start and Print Parameters. Schecule the Job.

2. Check in RSA7 for the delta Queue.

3. Go to BW system and Schedule for your Delta Package.

4. Delat data would be picked from R/3 to BW.

Now if you want you can change the update mode to Queued Delta.

Assign points if its helpful...

Regards,

Vidhya.A

[former_member195940]

Hi Shiba:

as you are saying, your setup tables has only one day data!!

go to your cube and drop the data.

go to SBIW and find the "delete set up tables" and delete the data for appl com 03

go to SBIW and fill setup tables for the 03

come to BW. find your infopcakage.

select the 2LIS_11_VAHDR_INIT infopavakge and under update tab select "Initialize delta" and then load.

create one more infopacakge 2LIS_11_VAHDR_DELTA and now this time select delta option and load. you will be all set.

Assign points if helpful

Thanks

kalyan Dittakavi

[Former Member]

Hi

Re initialize the delta update with out data transfer and you load deltas!

Regards

GSK

[Former Member]

I'd do a full upload and then a delta without data transfer, not the opposite.