PM30925: REPORT STUDIO GENERATING UNNECESSARY JOIN IN SQL

APAR status

• Closed as program error.

Error description

• When generating a report based off the following data items a
  join to another table (TARGET_VOLUME_FACT) is made through the
  WHERE clause which isn?t part of the query path. Tests from FM
  and Report Studio SQL (tabular) do not display this behavior,
  only SQL loaded from Tools ?SQL in RS and UDA trace show this
  join. A test at the database layer and dmr layer exhibit this
  behavior. ??
  

Local fix

• Remove join from model so sql doesnt add it
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * Pack 1 or Upgrade to IBM Cognos 8 Business Intelligence      *
  * 8.4.1 Fix Pack 4                                             *
  ****************************************************************
  

Problem conclusion

• The issue is a result of ambiguous join path. A detailed analysi
  s of how the ambiguity can be resolved to achieve the desired re
  sults is provided.
  

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

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA11 PSN

     UP