Skip to Content
author's profile photo
Former Member

Compression with zero elimination (reverse postings)

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 05, 2005 at 04:36 PM

    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=E

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

    Add comment
    10|10000 characters needed characters exceeded