PH59310: XQE-PLN-0091 CROSS JOINS ARE NOT PERMITTED AFTER UPGRADING TO 11.2.4 FP2 USING A REPORT WITH A FILTER FROM ANOTHER TABLE

APAR status

• Closed as fixed if next.

Error description

• After runing a report that contains query with a filter using a
  data item from another table, the following error is seen:
  RSV-VAL-0010 Failed to load the report specification.
  XQE-PLN-0091 Cross joins (between query subjects: xxxx) are not
  permitted.
  If Cross Product Allowed is set to Allowed, the output is
  incorrect.
  This has started occurring after Cognos Analytics was updated
  from 11.0.6 to 11.2.4 FP2 (11.2.4-2307061628)
  

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