Skip to Content
avatar image
Former Member

ADSO - Equivalent for Compression with Zero Elimination

Hello everyone,

I would like to know what is the equivalent for "compression with zero elimination" for ADSO with setting "All characteristics are key" i.e., infocube template.

Activation of such ADSO does the job of compression i.e., move inbound table data to active table data.

But it doesn't eliminate entries with zero measure values.

Is there any way to delete such records?

Thanks,

Anup

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 03 at 03:15 AM

    see note 2443489 - BW4SL - InfoCubes,

    The DataStore object (advanced) does not support "zero elimination" at present

    Add comment
    10|10000 characters needed characters exceeded

  • May 03, 2017 at 01:55 PM

    Try with somecode like this:

    delete from /BIC/Table1 where /BIC/ZKEYFIGURE= 0.

    Add comment
    10|10000 characters needed characters exceeded