PI43406: INCORRECT OUTPUT FROM CASE WHEN STATEMENT WHEN UNION QUERY IS REFERENCED

APAR status

• Closed as program error.

Error description

• Incorrect values are returned when a CASE WHEN statement uses a
  reference such as [UNION1].[PRODUCT_ID].
  
  ie. CASE  [UNION1].[PRODUCT_ID]
  WHEN 10001 THEN ...do something...
  WHEN 10002 THEN ...do another thing...
  ELSE 0
  END
  

Local fix

• Remove the reference to the union:
  
  CASE  [PRODUCT_ID]
  WHEN 10001 THEN ...do something...
  WHEN 10002 THEN ...do another thing...
  ELSE 0
  END
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.0 Fix Pack  *
  * 5                                                            *
  ****************************************************************
  Configuration Instructions:
  
  * Enabled by default but can be disabled by adding the
  propagateAggregationForSubqueryDataitemRefs flag to the
  'MDOperationProvider' configuration section in the
  qfs_config.xml file and setting it to false
  <provider name="MDOperationProvider"
  libraryName="qfsMDOperationProvider" serviceProvider="true">
      <providerDetails>
          . . .
          <propagateAggregationForSubqueryDataitemRefs
  value="false"/>
      </providerDetails>
  </provider>
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI42626

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA20 PSN

     UP