PM67519: FUNCTION AGGREGATE IS RESOLVED INCORRECTLY AFTER UPGRADE TO 10.1.1

APAR status

• Closed as program error.

Error description

• The client has upgraded a report from C8.2 to C10.1.1.??After
  upgrade, the function aggregate is not resolved
  correctly.????The returned value for the following "Pyramid
  Base" is incorrect.??<dataItem aggregate="total" name="Pyramid
  Base" rollupAggregate="total">??   <expression> case??
                  when [Work Category] in
  ('Foundational','Base','Unavailable','Overhead')??
              then aggregate([Hours Worked] auto )??
              else 0??                        end??
  </expression>??</dataItem>????It was because function aggregate
  in expression is always resolved to XMIN, instead of XSUM.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos BI Server 10.2                             *
  *  or  Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix  *
  * Pack 2                                                       *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

• Fixed component name

  COG8 BI COG CON

• Fixed component ID

  5724W12CC

Applicable component levels

• RA11 PSN

     UP