on 10-19-2011 2:32 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.