Question:
Hi all!
Is it possible to delete a specific request from an aggregate without using the selective deletion? The "compress after rollup" indicator is not set.
Is it possible to delete a specific request from the cube without de-activating the aggregates? If not, is it possible with the aggregates switched off? What we really want is the easiest way to get rid of a request which has been rolled up, from the cube and from the aggregates.
Thanks in advance for any input!
--Andreas
Answer:
Has anyone got any experiences to share regarding this? I've read a few posts touching on these subjects, but nothing spot on. Any thoughts would be welcome. Thanks!
Andreas
Answer:
Assuming the infocube has not been compressed, you should delete the request from the cube, which will cause the request to also be deleted from the aggregates. After the request has been deleted from the cube and aggregate(s), the system will rebuild aggregates automatically. Depending on the number of aggregates tied to the cube, this process may take a while to complete. This is to maintain data integrity between the cube and aggregates.
If the request has been compressed within the cube, a selective deletion must be performed in order to delete the data. Note: The same "delete and rebuild" process will occur with the aggregates.
Answer:
rojo is correct if you want to do this manually.
if you do this in process chain you have to do it a bit differently.
step 1 - load cube
step 2 - delete overlap from cube
step 3 - build index if u have any
step 4 - run db stats
step 5 - drop and reload aggregates ( i used an apab report for this using std function modules)
works like a charm ..........
p.s. - do not compress anything (cube or aggregate)
Answer:
Thank you guys! What really confused me was the help text about the compression indicator:
http://help.sap.com/saphelp_bw30b/helpdata/en/c5/40813b680c250fe10000000a114084/frameset.htm
It states that "A specific request can be deleted from the aggregates when it has been deleted from the InfoCube". Nothing about the automatic process.
When I tried to delete a request the delete button was greyed out. However, that must have been because of something else I didn't notice... I'll try it again next time its necessary.
Cheers!
--Andreas