Skip to Content
0
Dec 28, 2011 at 12:00 PM

Delete data from infocube which is older than 7 days.

191 Views

Hi Gurus,

I have a Cube with the time dimension characteristic as 0CALDAY. This cube gets data from a DSO ,which has 0calday as one of its key fields, in Delta mode. I am in a need to delete the data with calday in the previous week. i.e SY-DATUM - 0CALDAY >= 7 in the infocube.

I just tried to create a transformation such that both the data target and the source is the above mentioned DSO and used the technical rule group to set the record mode as "D" for the older records and it works fine with the DSO.

But the Cube still has the data. Just the keyfigure becomes zero. But i want to completely delete the data. I do not want to use "DELETE-FACTS" or the FM "rsdrd_sel_deletion."

Please help me get out of this problem.

Thanks in advance,

Rajesh.