Hi All,
We have a scenario where we need to use minimum exception aggregation. We have defined this at the infoobject level Agg=Sum and Exception Agg = MIN.
However, due to reversals, we gets ZERO values on the keyfigures. With this exception aggregation though, it captures the ZERO KF values as minimum which is NOT what we want. We want the valid minimum values of the key figure not ZEROs. In this scenario ZERO is not valid values.
We have done zero compression as well. This works by deleting the ZERO records but as we are using DB2, every compression will cause a LOCK to reporting. This is not the approach that we adopt in our architecture environment.
Has anyone used minimum excep aggregation which able to eliminate ZERO values?
thanks for ya help.
cheers
eddie