PM94756: IBM COGNOS BI REPORT JOIN QUERY SPLITS AGAINST INFORMIX CQM.

APAR status

• Closed as fixed if next.

Error description

• Report has queries:????- QueryTest??- QueryTijdperiode??-
  QueryJoinTest: join between QueryTest and QueryTijdperiode????
  -> generated native SQL: the query is split up in 2 separate
  queries, which is not good. Replacing one column in QueryTest
  and QueryJoinTest SQL produces single query.????The reason why
  he is splitting the query is unknown, maybe a defect.??Splitting
  query causing QueryJoinTest will be executed locally in
  the??Cognos server.????This prevents the use of informix stored
  procedure, if the??calculation is made in QueryJoinTest and
  executed locally, the Cognos??server will raise error because
  the stored procedure is not known to??Cognos which is normal
  behaviour.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 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

• RA22 PSN

     UP