Skip to Content
0
Former Member
Mar 26, 2009 at 12:41 AM

Exception Aggregation - MINIMUM excluding ZERO values

167 Views

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