Skip to Content

Delete the last delta load request from Infocube and last full load from DSO through process chain

Hello Experts,

I have a flow which loads full from DSO1 to another DSO2 and then delta load from DSO2 To Cube1.

I need to delete the last request from DSO2 and Cube1 before load everytime.

I have checked the SDN post :

(RSICCONT is table which the Request of all cube data Target .

code :-

data msid type i.

select max( sid ) into msid from RSICCONT where Icube = '<your cube name >'.

delete from RSICCONT where sid = msid and icube = '<your cube name>')

But using this process the last request deletion can be done but after deletion when I am loading it again it is giving me dump. As the old request just disappears from the manage screen of the cube but request status is successful.It could not make the request status as deleted.

What can be the solution



Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.