PH57871: DATA MODULE JOIN OPTIMIZATION UNEXPECTEDLY CHANGES AGGREGATE CALCULATION VALUES

APAR status

• Closed as fixed if next.

Error description

• Within a data module, when a query calculation with an aggregate
  function uses a FOR clause (i.e. Maximum(Quantity for Year_ )),
  the SQL calculates the max values for all values in the fact
  table. When changing the relationship optimization to "Unique
  values", the fact table is being filtered first and then the max
  calculation performed which returns different numbers and is
  unexpected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 12.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