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 number
PI43406
Reported component name
COG REPORT STUD
Reported component ID
5724W12RS
Reported release
A11
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-06-19
Closed date
2016-07-29
Last modified date
2016-07-29
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 REPORT STUD
Fixed component ID
5724W12RS
Applicable component levels
RA20 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
29 July 2016