Compression with zero elimination (reverse postings)

[Former Member]

I executed a compression with zero elimination in a custom InfoCube in order to avoid entries that only contain zero values as key figures (for example reverse posting) are contained in the InfoCube after compressing.

However, not all the entries where all the key figures are blank have been deleted.

This cube contains the following standard key figures:

-0DEB_CRE_DC;

-0DEB_CRE_LC;

-0DSCT_DAYS1;

There are also two other custom key figures, created as copy of 0DEB_CRE_LC.

Have you any suggestion?

[Former Member]

So you're saying you have rows in your E fact table that were created as part of this particular compression run where all KFs = 0? That certainly doesn't sound right.

The zero elimination is a multi-step process -

first excluding rows from the F fact table where all KFs are 0, then excluding any summarized rows where all KF = 0, and then finally, deleting rows from E fact table that were updated resulting in all KFs = 0. Were any compressions run on this cube previously without zero elimination specified?

What DB?

There have been some problems with Oracle 9.2 merge function.

https://websmp201.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=613701&_NLANG...

https://websmp201.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=639253&_NLANG...