cancel
Showing results for 
Search instead for 
Did you mean: 

Delta update via Date Field

former_member1173626
Participant
0 Kudos

Hi all,

I've read and used the How-To for generic delta and this is what I've done for my custom Z table:

1) I added a LAST_CHANGED field, type DATS;

2) In my datasource, I used that field for the delta;

3) I specified an upper limit of 1 and left the lower limit blank. I haven't found a solid explanation of what the upper and lower limits mean, so I'm not sure what are the proper values for these fields.

3) In the InfoSource, all I did was add the 0RECORDMODE InfoObject into the Communications Structure only. The "Transfer Rules" tab is yellow because nothing is defined for the 0RECORDMODE. Is this correct? The InfoSource does activate fine, however.

4) I loaded the ODS with the initial delta and it worked fine. Note that the LAST_CHANGED date in all the records were dates in the past (i.e., many months ago; none of them were recent).

5) I then added a new record with a LAST_CHANGED date of today and ran the delta update. But 0 records were selected.

How come? Does this have something to do with the lower/upper limit?

I am pretty lost as to what I need to do to get deltas fully working by date. Please help if you can.

Thanks,

mike

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mike,

Did you run the delta upload immediately after init load?

ReEgards,

Rohini

former_member1173626
Participant
0 Kudos

Hi Rohini,

After the init, I added a record in the Z table, then ran the delta. But I got 0 records. It always says 0 records in RSA7.

Thanks,

mike

Former Member
0 Kudos

Mike,

Did it give you any error mesg?

Answers (3)

Answers (3)

Former Member
0 Kudos

hi,

1) I added a LAST_CHANGED field, type DATS;

2) In my datasource, I used that field for the delta;

3) I specified an upper limit of 1 and left the lower limit blank. I haven't found a solid explanation of what the upper and lower limits mean, so I'm not sure what are the proper values for these fields.

*lower limit is going to be last update time

upper limit is going to be current update time

3) In the InfoSource, all I did was add the 0RECORDMODE InfoObject into the Communications Structure only. The "Transfer Rules" tab is yellow because nothing is defined for the 0RECORDMODE. Is this correct? The InfoSource does activate fine, however.

*you cant see the 0recordmode but it is an info object .but it will collect the changed kfs(keyfigures)

4) I loaded the ODS with the initial delta and it worked fine. Note that the LAST_CHANGED date in all the records were dates in the past (i.e., many months ago; none of them were recent).

5) I then added a new record with a LAST_CHANGED date of today and ran the delta update. But 0 records were selected.

How come? Does this have something to do with the lower/upper limit?

I am pretty lost as to what I need to do to get deltas fully working by date. Please help if you can.

former_member1173626
Participant
0 Kudos

Hi all,

I got it working...since it was a date field, it was just a matter of waiting for one day. Yesterday, I am presuming that even though I had a LAST_CHANGED date value in the future (it was set to Today), that BW only extracted the delta based on the date from RSA7 up to the present day.

However, I am still confused as to whether or not I need 0RECORDMODE in my InfoSource. Do I really need that in my example or is that only when I am manually/programmatically filling the delta queue?

Thanks,

mike

Former Member
0 Kudos

Mike,

You should have 0RECORDMODE object in case of ODS.

Regards,

Rohini

former_member185837
Active Participant
0 Kudos

<i>You should have 0RECORDMODE object in case of ODS.</i>

Even when using the <b>generic delta</b> mechanism? I think that deleted records are not transmitted to BW for deletion.

As they're simply not there anymore, they of course can't have a change date. As a consequence, they can't be transmitted to BW.

I can't figure out how the 0recordmode Info Object could be used in this case.

Thanks all, Davide

Former Member
0 Kudos

Hi,

Please check whether ur added field is having the same settings like the other fields.. U can check it in the ROOSFIELD table.

Regards-

MM

former_member1173626
Participant
0 Kudos

I read in another message thread something about the delta queue gets created, but not filled. In order to do that I have to run a collective job or something.

What's that and how do I do it?

Thanks,

mike