PM08723: UNEXPECTED SQL WITH NON CONFORMED DIMENSIONS. JOINS AT AN INCORRECT LEVEL.

APAR status

• Closed as program error.

Error description

• Unexpected SQL join when creating a multi fact multi grain query
  on non conformed dimensions and another non conformed dimension
  is created with determinants. If determinants on that dimension
  are removed, the SQL is correct, but the resultset is incorrect,
  since determinants are needed to get the correct granularity of
  the resultset.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos 8 Business Intelligence 8.4.1 FP2.     *
  *                                                              *
  * The CQEConfig.xml.sample file under                          *
  * c8_location\configuration on the App Tier will               *
  * need to be renamed to CQEConfig.xml, and a new section:      *
  * <section name="Transformations">                             *
  *    <entry name="CheckSharedDeterminants" value="1"/>         *
  * </section>                                                   *
  *                                                              *
  *                                                              *
  * Needs to be added for this fix to take effect.               *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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 BI FRAMEWK

• Fixed component ID

  5724W12FM

Applicable component levels

• R841 PSN

     UP