PH50443: COGNOS NOT INCLUDING _ADD_[TIME] FILTER FUNCTION FOR DENODO DATASOURCE

APAR status

• Closed as fixed if next.

Error description

• When attempting to filter a denodo datasource, when filtering
  based on an _add_[time] function (e.g. _add_year, _add_month,
  _add_days) the query does not include this to the datasource,
  therefore not filtering the query. Cognos instead chooses to
  local process this.
  
  Denodo does support _add_time function. One way we tested this
  is with user-defined SQL.
  
  You can visibly see this in the "generate native sql" option.
  

Local fix

• Workaround:
  Use user-defined SQL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2.4                       *
  ****************************************************************
  

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