PM73244: TERADATA 133.10 - OLAP FUNCTION 'SUM' IS NOT SUPPORTED BY THE DATABASE

APAR status

• Closed with unknown close code.

Error description

• Attempt to apply a filter on Business Insight Advanced list
  report will result in error:??The request could not be run
  because the feature is not supported or a server error
  occurred.??RQP-DEF-0177 An error occurred while performing
  operation 'sqlPrepareWithOptions' status='-120'.?UDA-SQL-0458
  PREPARE failed because the query requires local processing of
  the data. The option to allow local processing has not been
  enabled.?UDA-SQL-0475 The OLAP function 'sum' contains a clause
  (AT or PREFILTER) that is not supported by the database. This
  operation requires local processing of the data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

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

• Fixed component name

  COG ADMINISTRAT

• Fixed component ID

  5724W12AD

Applicable component levels

• RA21 PSN

     UP