cancel
Showing results for 
Search instead for 
Did you mean: 

Process Type - Delete overlapping requests from an Info Cube

Former Member
0 Kudos

I have read many threads on this topic, still have some questions. To give you background, I will be doing delta load (“delta” process chain). But before delta, I want to do setup initialization (“init” process chain). I want to use this process type in my “init” process chain” to delete all data in my cube loaded from a specific ods. I cannot use delete all contents process type because many ods’s feed the same cube.

1. Do you put this process type after Load Data or before Load Data. I have seen both cases in SDN forums.

2. Variant of this process type is an info package. Does this info package have to be same as in load data step or it can be different.

3. I want to delete all data in cube which was loaded from my ods. Term overlapping is confusing to me. Will this process type delete all data or not.

Tanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I remember, you should select the setting 'delete contents before load' in the infopackage. so when this infopackage is run, the contents of the infocube is deleted before loading. In case the load fails the data wont be deleted.

Is this what you are looking for or something else?

Thanks.

Former Member
0 Kudos

I do not want to delete all the data only data loaded from that ODS,

former_member496813
Active Participant
0 Kudos

Yes, you can do that. Goto RSPC - under process types Load Process and Post Processing, you will see DELETE OVERLAP REQUESTS FROM INFOCUBE option is there.

Select the proper check boxes like same sourcesystem, same datasource etc...

If it is one time deletion, why not do that manually?

Also check:

Hope it helps..

Former Member
0 Kudos

I am looking for some example - sctreens, how people do use this process type. Have not found any.