PM94469: PROPERTY "V5.SUPPRESS.NULLS.USEPREAUTOAGGREGATIONMEASUREDETAILFI LTER=TRUE" THROWS XQE-PLN-0080

APAR status

• Closed as program error.

Error description

• Customer is using a DMR project. The property
  "v5.suppress.nulls.usePreAutoAggregationMeasureDetailFilter=true
  "
  was enabled in dmr.properties file. Now when running a report
  with a multi fact query and Detail Filter in DQM following error
  will be thrown:  "XQE-PLN-0080 SQL cannot be generated, because
  the following filter condition: DetailFilterFromWrapper could
  not be applied to any of the following fact streams in the multi
  fact query:" ?In CQM the report runs fine. Without the property
  enabled in dmr.properties file the report runs fine, too.
  

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  *
  * 1                                                            *
  ****************************************************************
  

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

• Fixed component ID

  5724W12FM

Applicable component levels

• RA21 PSN

     UP