JR36526: AVERAGE AGGREGATION FUNCTION DOES NOT EXCLUDE NULL VALUES

WebSphere Business Monitor development toolkit V7.0 Fix Pack 3 (7.0.0.3)
WebSphere Business Monitor development toolkit V7.0 Fix Pack 5

APAR status

• Closed as fixed if next.

Error description

• The Average aggregate function (used as a measure) does not
  ignore null values in the instance data but instead includes
  them as zero values, which is incorrect behavior.  The
  WebSphere Business Monitor Information Center documents the
  correct behavior (see
  http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/c
  om.ibm.btools.help.monitor.dev.doc/toolkit/mme/aggregationfuncti
  ons.html):
  
  "Similarly, the Average function averages the values that are
  not null. Suppose you have an Average Order Amount measure that
  points to an Order Amount metric. At run time, you have three
  instances with order amounts of $100, $200, and null. The
  Average Order Amount measure ignores the null instance and has a
  value of $150."
  

Local fix

• The cube definition can be updated in the AlphabloxAdmin console
  directly as follows.  Copy the argument in the SUM() function to
  the COUNT() function, for example:
  
  Original measure definition:
  DOUBLE(SUM(@col(ORDERITEM.MCU_ORDERITEM_MC.M_DELIVERYDURATION)))
  /COUNT(1)
  
  Revised measure definition:
  DOUBLE(SUM(@col(ORDERITEM.MCU_ORDERITEM_MC.M_DELIVERYDURATION)))
  /COUNT(@col(ORDERITEM.MCU_ORDERITEM_MC.M_DELIVERYDURATION))
  

Problem summary

• This problem exists in monitor models generated with any of the
  following:
  
  - WebSphere Business Monitor development toolkit Version 6.1.2,
  Version 6.2, and Version 7.0
  
  - WebSphere Integration Developer Version 7.0 (Monitor model
  editor feature)
  
  This problem will be resolved in the following fix packs:
  
  - WebSphere Business Monitor development toolkit V6.1.2 Fix
  Pack 6 (6.1.2.6)
  - WebSphere Business Monitor development toolkit V6.2 Fix Pack 3
  (6.2.0.3)
  - WebSphere Business Monitor development toolkit V7.0 Fix Pack 3
  (7.0.0.3)
  - WebSphere Integration Developer V7.0 Fix Pack 3 (7.0.0.3)
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R612 PSY

     UP

• R620 PSY

     UP

• R700 PSY

     UP