Hi,
We are compressing a cube with zero elimination. All KFs are cumulatives with aggregation behavior of SUM.
For some reason certain rows for which all KFs are zero are not being eliminated from the E fact table. I have looked back over past requests and do not see any compression failures.
Has anyone ever encountered this issue? Any theories on why the zero elimination isn't working? Better yet, any recommendations for how these records can be eliminated from the E table now that the data have already been compressed?
Thanks,
Bob