Question Re: Data Inconsistency in Technology Q&A

Data Inconsistency

Former Member — Wed, 17 Nov 2010 01:56:32 GMT

Hello experts,

I have created a generic data source to pull employee master data (time dependent) from info types PA9100 and PA0014 which have wage types and bonus.

For this I am doing full load into bw.But I am getting errors like " overlapping time intervals of data records 1 with 2(to/from)" for many records.When I checked the data i realized that it is because of the same from date and to date repeating.Like for example:

Record Perno From date To date wage type amount

1 111 03/04/2010 04/05/2010 AA 50

2 222 03/04/2010 04/05/2010 BB 100

Can some one help me over come this issue..

Thanks

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 02:42:26 GMT

Hve u defined From and To date as the key?

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 02:45:07 GMT

To date is defined as key.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 02:49:39 GMT

Thats why you are getting this erorr. Only date can never be a key. It has to e with combination with some other characterstic.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 02:51:27 GMT

No, date to and emp no are defined as keys.Date from is not defined as key.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 02:55:51 GMT

What i meant that date to and emp no combination might not be unique in the load. Try including some other characterstic which will make the 3 combinations unique.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 02:58:23 GMT

Can you please guide me how to do that..

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 03:02:00 GMT

While creating Cube/DSO, you need to define which all characterstic will be your key.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 03:04:27 GMT

this is actually master data loading..employee master data..

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:04:16 GMT

Hi,

For some employees there might be multiple records and the from date and to date might collide. Plz check.

Regards,

Raghavendra.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:12:50 GMT

Hi,

Actually the problem is for some employees the from date and to date are same but only the wage type and amount changes.If I do not tick the handle error records under update tab in DTP, the data load has errors overlapping dates and if I check that option then the repeated dates records are deleted.I need all the records bcoz for those records there is a change in the wage type.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:18:48 GMT

Hi,

How can an employee have multiple wage type in a same timeframe. Logically this is not possible? Plz check.

Regards,

Raghavendra.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:26:11 GMT

Hi Raghavendra,

I have checked, for the same dates the employee has different wage type(sub type) and amount.This data is taken from infotype pa0014.

Wagetype From date to date amount

6791 03/07/2010 03/20/2010 32

6755 03/07/2010 03/20/2010 8

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:31:34 GMT

Hi,

If this is the case then you cannot load it in 0employee master, because your thing does not satisfy as master data criteria. You can use DSO for your purpose or you should compound wage type to ur master data(which i think is wrong) and load. Plz check with ur HR consultant whether a single employee can have multiple wage type for a given period.

Regards,

Raghavendra.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:37:20 GMT

ok.Here I have created a zemployee with only fields from date, to date, wage type, amount.And getting the data from a generic data source to get records from info types pa0014 and pa9100.Would making the data source delta capable solve the issue.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 04:42:23 GMT

Hi,

Ok. Let us say what is the use of your zemployee then? If all the fields are compounded then what are the attributes of zemployee? even if there are attributes then you have to have wagetype, amount and what ever field you have compounded in your transaction data to display the attributes in report. Plz check whether this is what u require?

Regards,

Raghavendra.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 05:04:08 GMT

I have taken wage type, amount as attributes of zemployee.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 05:05:54 GMT

Ok. Again we are back to square one :-). If these r attributes then for a particular time period you can have only one value for the employee.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 05:09:10 GMT

Basically I need a report which should show the transactions whose wage type(1sti/1lti) or bonus changes in a user selected time range and it should also show the previous wage type or bonus.So for that I am taking the data from the info types pa0014 and pa9100 into info object zemployee which have wage type, amount as attributes.

I have the wage types in one of the existing cubes but since it does not hold the history and also does nt show when it changed(from and to dates) I am goin for info object and reporting on master data.

Re: Data Inconsistency

Former Member — Wed, 17 Nov 2010 14:20:42 GMT

I hope you got what I am looking for..if you have any idea, please share..