on 09-27-2005 4:15 AM
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
Hi Mike,
Did you run the delta upload immediately after init load?
ReEgards,
Rohini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
<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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.