Data Extraction From HR with Delata Update fro Payroll

[Former Member]

Hi All,

this is Chava,i got a problem with HR Data.Already i did Full Update,Delta Initialization but after that They did some changes in HR Cluster tables and they extracted Data from R/3 in to BW WIth Functional Module.

Now the problem is Delta Update is not completing.

I need to do any Extract Structure activation and how?

Please help me, its a very big problem.

Thanks

Chava

[Former Member]

chava,

you dont need to do the activation of extarct structure. check with your developer. also run the test or check for that FModule in se37.

if you are extracting data from time cluster table it take a while to extract data more likely for 0HR_PT_2 data source.

Thanks

Q

[Former Member]

Thanks for your message and that i will be in touch with you.

Regards,

Chava

[former_member184494]

Chava,

Welcome to SDN ,

Did you check the Delta update in RSA3 ? does the delta happen properly ? if it does , then:

1. Check the Delta Queue in R/3 ( RSA7) for your datasource and see if the problem is that the delta queue is corrupted since the structure resembles the older version.

then

1. Replicate the data source again into BW

2. Do the Init again

3. Load some delta data in R/3

Hope this helps....

Arun

Assigning points is a way of saying thank you in SDN

Message was edited by: Arun Varadarajan

[Former Member]

Hi All,

There is no Delta Queue in RSA7,but i want to do Delta Update for HR Data,what i have to do?

REgards

[Former Member]

Hi Chava,

Let me give you some points on 0HR_PY_1 .

This datasource is Delta Supported and it can be used to load data in ODS as well as Infocube as the request gaurentees serialisation.

As per your requirement,first do a Init Delta with out data transfer and then load selective repair requests for the rest of the data . When the delta initialization is done successfully then you can see your datasource in RSA7 . But you have indicated that your collegues have changed the Cluster tables( you mean to say as the HR Payroll data gets stored here) ,I dont have a clue as how this happens as the standard extractor doesnt mind at the changes in the data at base tables .

But make sure you do a successful initalization.

You have mentioned that you have done a FULL UPDATE ,Delete that request and then do a Init Load then you can have the delta loads.

Hope it Helps..

Thanks,

Krish

*Assigning Points is the best way to say thanks in SDN