Compress infocube with zero elimination

[Former Member]

Experts, Is that true you should always check "with zero elimination" when you compress infocubes? I was reading the famous SAP doc "How to Handle Inventory Management Scenarios in BW", the screen shots for cube compression does not have that checkbox checked. Does anybody know why?

Thanks!

[Private_Member_101989 · Accepted solution]

Hello,

Using the zero elimination the entries where all key figures are equal to zero are deleted from the fact table during compression. You don't want that in Inventory Management.

Regards,

Jorge Diogo

[Former Member]

Hi,

In inventory compression is done to update the marker and therefore the compression has a bit differerent effect then the original compression process in normal cubes.

Since marker is updated therefore we do not need to update 0 here.

Thanks

Ajeet