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 CUR111 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.