Question Re: Delta repeatation/delta update in Technology Q&A

Delta repeatation/delta update

Former Member — Tue, 03 Sep 2013 07:23:35 GMT

Hi all,

I small question about delta records.

talking about tx RSA7

In RSA7 we have to tabs

1. Delta update

2. Delta repeatation

in what scenario they both has effective usage in data warhousing

So can give more idea and depth detail about above.

thanks & regards

Re: Delta repeatation/delta update

MGrob — Tue, 03 Sep 2013 17:28:18 GMT

Delta repetition only comes in play once a delta load has not successfully finished in bw and needs to be repeated in order to go back to the normal delta queue behaviour

Hope it helps

Martin

Re: Delta repeatation/delta update

anshu_lilhori — Tue, 03 Sep 2013 17:32:25 GMT

This message was moderated.

Re: Delta repeatation/delta update

RamanKorrapati — Tue, 03 Sep 2013 17:34:05 GMT

Hi,

Delta - as usual delta.

Repeat delta - When the last delta was failed, by using repeat delta we can get back those data as well as present data.

At info pack level when we set as red for last delta request, then only we get repeat delta option for the same info pack.

Thanks

Re: Delta repeatation/delta update

former_member182470 — Tue, 03 Sep 2013 19:17:51 GMT

Hi taniya,

RSA7 : In simple

Delta Update : This will show you How many delta records are ready to process to BW

Delta Repetition : This will show you , What has already been loaded to BW, so that you can again run repeat delta if the last delta load was not successful in bw side.

Regards,

Suman

Re: Delta repeatation/delta update

former_member182196 — Wed, 04 Sep 2013 07:03:51 GMT

This message was moderated.

Re: Delta repeatation/delta update

Former Member — Wed, 04 Sep 2013 10:14:58 GMT

Dear Suman/Raman/Martin,

Nice and thanks

1. Enabling or selecting Delta at RSA7 for default has any effect on data loading.

2. Will there be data always present in delta repeatation table (RSA7 --> delta repeat ---display---> execute) if yes then how long it would be there?

Regards

Re: Delta repeatation/delta update

Former Member — Wed, 04 Sep 2013 11:22:00 GMT

Hi,

As others have already informed, its quite simple.

Delta Update --> Records to be further send to BW.

Delta Repetition --> Records which are already send to BW but might be needed to called back to BW as " Repeat of Last Delta" if the last delta loads fails in BW.

Br,

Arpit

Re: Delta repeatation/delta update

RamanKorrapati — Wed, 04 Sep 2013 11:34:58 GMT

Hi,

1.Manually we won't select at RSA7. we set delta set up at info pack level only..

2. i think it may hold latest delta request data only. if last delta req was failed info pack, that request will hold at delta repetition.

once delta request was success at info pack level, automatically delta repeating will be zero.

Thanks

Re: Delta repeatation/delta update

anshu_lilhori — Wed, 04 Sep 2013 11:36:53 GMT

Hi,

1. Enabling or selecting Delta at RSA7 for default has any effect on data loading--Their is no effect on data loading,its just to see the data in both the modes.

Data in delta queue will be present until next successful load in BI.

So if your first load is successful in BI and then also it will maintain the same data which you can check in RSA7 by selecting the option repeat delta.

Once you load the second day delta then the first day delta will not be available in repeat delta the records will be replaced by second day delta.

Thats how this works.You can give a try for more understanding on the same.

Regards,

Re: Delta repeatation/delta update

MGrob — Wed, 04 Sep 2013 11:38:48 GMT

1) You actually don't need to do anything in rsa7. Deleting data in there would cause inconsistency in bw.

2) As Raman pointed out as soon as you create an Init with infopackage in BW you'll see an entry in RSA7.

hope it clarified

Martin

Re: Delta repeatation/delta update

Former Member — Wed, 04 Sep 2013 11:58:52 GMT

Dear Raman/Martin/Anshu/Arpit,

I agree with all lines.

1. Suppose if the delta repeat in RSA7 has years of data though delta loads are running on daily successful basis. At this situation?

2. Can I make repeat delta repeat table or content in RSA7 empty with ensuring all success full deltas in bw.

3. After successful delta load if i wantedly marked status as to repeat delta then missed data of previous year would be loaded to bw system.

Thank You so much again for more descriptive explanation.

Re: Delta repeatation/delta update

former_member182470 — Wed, 04 Sep 2013 12:06:54 GMT

For your complete understanding about Delta Queue. Please go through this superb doc:

http://scn.sap.com/docs/DOC-11261

Re: Delta repeatation/delta update

RamanKorrapati — Wed, 04 Sep 2013 13:15:30 GMT

Hi Taniya,

1. Delta repeat holds only latest req. there is no chance to hold years at RSA7. Delta means updated data on daily basis.

2. At RSA7 - there is nothing to set. its just for display

3. No. If you set green/success request to red. there is no chance to get last req records. because once req was green, system may sends green/success message so there is no chance have repeat option in this case. think so.

Repeat Delta: For example:

My loads are happening daily at 7AM. so today one delta load was failed. so today request was red. So again i will make my req to red a tpsa level.

i will run my info pack manually, its as last delta red was failed want to do repeat delta, i say yes. its brings yesterday data(Yestreday 7am to today 7 am) and today data(as of now, Today 7 am to 7PM(now my time is 7pm), which are reached to RSA7).

That's the use repeat delta. other that there is no situations to consider about repeat delta.

Thanks

Re: Delta repeatation/delta update

MGrob — Wed, 04 Sep 2013 13:24:53 GMT

1. Suppose if the delta repeat in RSA7 has years of data though delta loads are running on daily successful basis. At this situation?

Repeat delta only contains the last broken entry there is no such thing as a big queue..

2. Can I make repeat delta repeat table or content in RSA7 empty with ensuring all success full deltas in bw.

You should not delete anything in rsa7. it only leads to inconstencies. If you delete the init in bw it will also clean the queue.

3. After successful delta load if i wantedly marked status as to repeat delta then missed data of previous year would be loaded to bw system.

once a successfull delta pickup happened you don't need to do anything. actually you never need to do anything in rsa7. you can do all from bw side. the repeat of a unsucessful delta load you trigger in bw and rsa7 will manage itself

martin

Re: Delta repeatation/delta update

anshu_lilhori — Wed, 04 Sep 2013 13:51:45 GMT

Hi Taniya,

1. Suppose if the delta repeat in RSA7 has years of data though delta loads are running on daily successful basis. At this situation?
Delta queue will only hold data of the last request and it will maintain until the next successful request loads into BI.I have already explained the same in my last reply.So in any case if your delta loads are running daily then it wont have years of data.

2. Can I make repeat delta repeat table or content in RSA7 empty with ensuring all success full deltas in bw.
Everything you need to do in BI nothing in RSA7. Only in case your delta load fail then you can request for repeat delta by triggering the infopackage again.

3. After successful delta load if i wantedly marked status as to repeat delta then missed data of previous year would be loaded to bw system.
Nothing will happen if you change the setting to repeat delta in RSA7 that is only for displaying the data in queue.

I hope all your queries have been answered in case you need more info.i would suggest to try it practically on your DEV system provided you have access to it.

Regards,
AL

Re: Delta repeatation/delta update

Former Member — Wed, 04 Sep 2013 14:31:44 GMT

Hi Taniya,

Adding to the above posts... For more detailed info check the below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0709b9f-acbc-2c10-7a95-ab0ee18b921c?quicklink=index&overridelayout=true

https://scn.sap.com/thread/2107335

Regards

Re: Delta repeatation/delta update

Former Member — Mon, 09 Sep 2013 06:40:29 GMT

Hi Raman,

sorry to respond late.

Thanks

For 3 answer

As you knew about my last thread where i asked about the system which was stopped long back. So in that situation if the last delta of year 2012 is failed and running repeat delta in 2013 could successfully bring all records.

Thanks again for briefing more.

Regards

Re: Delta repeatation/delta update

Former Member — Mon, 09 Sep 2013 06:44:05 GMT

Hi Martin,

sorry to respond late.

Thanks for nice response

For 1 answer

Can you please elaborate

Thanks again

Regards

Re: Delta repeatation/delta update

Former Member — Mon, 09 Sep 2013 06:47:43 GMT

Hi Anshu,

sorry to respond late.

Thanks

yes i have gone with your previous reply, but i wanted to know more so i asked.

this time it is more clear from you.

Thanks again for briefing more.

Regards