Skip to Content
0
Former Member
Sep 15, 2005 at 09:55 AM

Selective Deletion on key-figure

101 Views

We are currently running SAP BW 3.0B SP 24 on Oracle 9.2.0.6.0. On a very big cube we have lots of key-figures, which are all 0.

As there is a bug on SP 24 with compressing those 0-values and we have not prepared this cube for decent compressing, this is not an option for us.

And we don't want to reload the cube (will take a weekend).

So the plans are to make a little ABAP routine, which does the job, maybe with some "Commit work"-statements during deletion.

The problem after this is still that the table should be somehow reorganized after that, therefor I decided to contact SDN.

Some ideas on this issue and the whole problem itself?