Question Re: Reset delta function not available? in Technology Q&A

Reset delta function not available?

Former Member — Mon, 09 Jul 2012 14:08:47 GMT

Hi.

I read an article (http://scn.sap.com/docs/DOC-26964) how to reset the delta management in a DSO. I like to use this feature to reset delta on request level between two BW systems which are connected by export datasource.

But I can only see the Where-Used-List dialog. Reset of delta for the target system is not possible.

Could somebody give me a hint why "reset delta management" is not available?

Thanks in advance,

Nils

Re: Reset delta function not available?

Former Member — Mon, 09 Jul 2012 14:28:27 GMT

Do you use a 3.x flow as in the article?

Loading from BW to BW is in fact the same as from ECC to BW.

Re: Reset delta function not available?

Former Member — Mon, 09 Jul 2012 14:41:02 GMT

No, I use transformations and DTP.

So if I like to load a request again I have to filter it with a repair/full from target BW and I cannot send the request again from source BW. Is that right?

Do you know if it is possible to recognize a deletion of a request in the source in the target BW or include the source RequestID in PSA? As I know deletions are not supported by the interface yet so it would be nice to include the requestid of the source BW in the data flow of the target.

Re: Reset delta function not available?

Former Member — Mon, 09 Jul 2012 14:55:52 GMT

With delta only once, unless you delete the delta. Full loads: as much as you want.

What exactly is your question about the deletions? Are loads in source BW which are already transferred deleted?

Re: Reset delta function not available?

Former Member — Mon, 09 Jul 2012 15:08:58 GMT

Yes, this is the case.

And because the source BW is located in a different country the information about deletions are not communicated in every case. So sometimes the data is inconsistent and it would be nice to delete the request in target system accordingly to the deleted request in the source. Manually or better automatically.

Today we make a selective deletion and run a full load with filters to have everything repaired.

Cheers,

Nils

Re: Reset delta function not available?

Former Member — Tue, 10 Jul 2012 08:26:25 GMT

Maybe run a custom program in the source regularly which checks if requests are deleted from the cube? And have it mailed to you or something?

Re: Reset delta function not available?

Former Member — Tue, 10 Jul 2012 12:15:39 GMT

Hi.

At the beginning I had some hope that this issue could be solved in the standard, but now think this is not possible.

Do you know the table which holds the list of deleted request? I could remember there is one, but I have to look for it. Perhaps you know it and I can save some time.

Re: Reset delta function not available?

Former Member — Tue, 10 Jul 2012 12:20:21 GMT

Hi,

Check the below document for Delta Reset.

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

Regards,

Rajesh

Re: Reset delta function not available?

Former Member — Tue, 10 Jul 2012 14:19:47 GMT

Not by heart. I'll have to search for it. What I do know that entries are written to the application log (SLG1) in case of a delete of a request.

Re: Reset delta function not available?

Former Member — Tue, 10 Jul 2012 14:23:01 GMT

I think it's RSBKREQUEST or something.

Re: Reset delta function not available?

Former Member — Wed, 11 Jul 2012 09:12:24 GMT

Cool. I can now identify the deleted request automatically in the source...next problem. 🙂

I cannot load from the export Datasource request by request so many source request are included in 1 target request (n : 1) .

Issues:

I cannot load a specific request from source BW (as I know).
I cannot include the source requestID in the dataflow for perhaps deleting it by selective deletion to only delete the request that was removed in the source
If I changed the delta management pointer to the request I have to reload every request that is newer will be transferred also.

Have you an idea how to handle one of the issues to repair the issue on request level? (Actual solution is to filter on the business data).

Cheers,

Nils

Re: Reset delta function not available?

Former Member — Wed, 11 Jul 2012 09:28:00 GMT

Unfortunately no. I also use filters or reset delta.