Skip to Content
0
Former Member
Feb 13, 2014 at 12:47 PM

Cube compression WITH zero elimination option

28 Views

Hi Experts,

I need suggestion in the below scenario.

I have one request in Cube with below data set.

PO PO ITEM PO VALUE CUR

111 1111 2000 EUR

Now this request was compressed with zero elimination.

later I got the below data set with changes in the existing record.

PO PO ITEM PO VALUE CUR

111 1111 -2000 EUR

111 1111 3000 EUR

Now I need to compress this request with zero elimination.

What will happen? what will be the result in the cube?

Does zero elimination will take place in F table or E table or both?.

in my production system, I can see many zero records even though we compressed the request with zero elimination.

your help much appreciated.