How to compress a planning ADSO of type InfoCube-like with zero elimination?

[RafkeMagic]

Hi,

we've been working on a "budget tool" (using BI-IP/PAK) in BW7.5 (SP05) Powered by HANA and our main objects are ADSOs of type InfoCube-like. We have been doing quite a lot of reposts (because of ongoing changes in the "business"), hence we're facing a lot of 0-records.

Obviously we would like to remove those 0-records like we did in the past (pré-HANA) with a compression using zero elimination, however we don't have that option. The planning functions to "repost and remove data from DSO" don't seem to work on these ADSOs (they do work on the "direct update" ones, which we're not using though).

Does anyone have any idea on how to achieve this? The standard documentation is rather vague about all this...

Kind regards,

Raf

[RafkeMagic]

We have a work around in place for this, where we basically offload our planning ADSOs to 'backup' ADSOs (using 1 - 1 transformation indeed). This already compresses a bit (e.g. for 1 reposted line which in fact are 3 lines in the planning ADSO we only keep 1 line in the 'backup' ADSO).

Then we empty the planning ADSO (or just remove the requests that we have just backed up).

Afterwards we reload the 'backup' ADSO into the planning ADSO were we have indeed a simple (AMDP) start routine that delete's the 0 lines.

And finally we activate that request.

[RafkeMagic]

Our AMDP start routine looks like this:

OUTTAB = SELECT * FROM :INTAB WHERE [KF1] <> 0

OR [KF2]<> 0

OR [KF3]<> 0

OR [KF4]<> 0

OR [KF5]<> 0;

where [KF1] - [KF5] should be replaced with our actual key figures of course.