IBM Support

PM99730: DQM CONTEXT SENSITIVE JOIN SELECTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer is getting a warning: XQE-WRN-0042 Join optimization:
    used the alphabetically first fact table...??The join is not
    going through the expected fact table based on how the Customers
    model organized...??This problem has been addressed in 10.2.1.1
    (caspian rp1 fp1) which is not what the customer has.??The
    behavior of join selection can be controlled by the user via a
    governor in the model:??DQM Context Sensitive Join Selection??By
    default it is disabled and will choose the alphabetically first
    fact table. The user can control this by setting it to
    Automatic.??This technote talks about (DQM) Context sensitive
    join selection in details
    ??http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=
    %2Fcom.ibm.swg.ba.cognos.dyn_query.10.2.1.doc%2Fc_dqm_governors.
    html
    ?
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 2                                                            *
    * or IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM99730

  • Reported component name

    COG FRAMEWRK MG

  • Reported component ID

    5724W12FM

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-23

  • Closed date

    2014-03-31

  • Last modified date

    2014-03-31

  • 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 FRAMEWRK MG

  • Fixed component ID

    5724W12FM

Applicable component levels

  • RA20 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWR","label":"Framework and Map Manager v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A20","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
31 March 2014