cancel
Showing results for 
Search instead for 
Did you mean: 

Selective Deletion from Infocube Only (Not from Aggregates)

Former Member
0 Kudos

Hi,

For the Selective Deletion, i used the FM 'RSDRD_SEL_DELETION' in program. But this FM deletes the data first from Infocube then from aggregate.Because of this, deletion took more time to delete and adjust the Aggregate.

I need an way in which i can delete the data from Infocube only and after i reach to my reconcile period then i will deactivate and actiavted the aggregate, so the data will be consistent in Infocube and aggregate.

is there any to Delete(Selective Deletion) the data only from the Infocube not from its aggregate (for the Performance Point of View)?

Thanks in Advance.

Regards,

Himanshu.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Himanshu,

There is no proper procedure to delete (selective deletion) in CUBE but not in the aggregate at the same time..Even if we switch off the aggregate it is going to delete from the aggregate also.because

System will not restrict you to delete the Request/Selective deletion from the Infocube, when the cube has a aggregates. But, the deletion job, deletes the data from the cube and triggers the job for refilling/rebuilding the aggregates. You can observe this, if you go through the deletion job in the SM37 job log.

Regards,

Sidhartha Satapathy

Former Member
0 Kudos

Hi

You can try manual selective deletion which will delete data from cube only. check out the below thread.

If you want to delete data from FM only, then try to deactivate your aggregates before you start your selective deletion.

Once deletion is done, you can reload the aggregates

Regards,

Venkatesh

Former Member
0 Kudos

Hi Himanshu,

Data deletion from Infocube without deleting from aggregates is not possible. If you are concerned about performance then deactivate all the aggregates and then do the selective deletion. Once deletion process is completed you can reload your aggregates.

Regards,

Durgesh.

anindya_bose
Active Contributor
0 Kudos

Himanshu

That is not possible, because that means you are trying to create inconsistency between cube and its aggregate.

In that case a query will show different result based on the condition data is coming from cube or aggregate.

But you can definitely delete the aggregate ( data only) first -


Then do your selective deletion and then refill the aggregate whenever required.

Regards

Anindya