PH04679: XQE-PLN-0020 FOR SPECIFIC COUNT DISTINCT SCENARIO

APAR status

• Closed as fixed if next.

Error description

• A report that uses the same data item with count distinct
  aggregation in columns and rows, as well as 3 other data items
  in a crosstab is failing with: XQE-PLN-0020 The V5 Query could
  not be planned by the Query Service. The 'V5Edge' node is
  invalid for the OLAP Transformation Library and the Query
  Service Planner is currently not able to resolve it.
  The same report can be executed successfully if one of the data
  items is removed, or when the report is executed in Compatible
  Query Mode.
  

Local fix

Problem summary

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

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