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?