PH03916: SUM(1) STITCH QUERY RETURNING INCORRECT RESULTS IN CROSSTAB

APAR status

• Closed as fixed if next.

Error description

• Client has a model that uses several stand alone calculations
  that span multiple facts. When they write a specific report as a
  list, they get the expected results. But when they write the
  same report as a crosstab, many rows of data go missing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.2                       *
  ****************************************************************
  Configuration Instructions:
  
  Under <XQEConfiguration> tag of xqe.config.xml file, add the
  section <ParameterMaps> below.
  If no setting is present, stitching full outer join is NOT used
  for list report,  but used for cross-tab report.
  If setting to false, stitching full outer join is NOT used for
  both list  and cross-tab reports
  If setting to true, stitching full outer join is used for both
  list and cross-tab reports
  
  
  <XQEConfiguration>
  
  	<ParameterMaps>
  		<map name="_governor" priority="90">
  			<entry name="suppressDuplicateMeasureValues" value="false"/>
  		</map>
  	</ParameterMaps>
  
  </XQEConfiguration>
  

Problem conclusion

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

Applicable component levels