APAR status
Closed as program error.
Error description
If a measure expression contains an aggregation function like count, the aggregation rule for that measure is ignored. Example: A count measure within a DMR contains the LAST aggregate rule for the time dimension. The count measure expression is: count([DB].[Table].[Employee count]) Note: this same behavior will occur for any aggregate rule function specified (ex. minimum, maximum, last ) When creating a crosstab, the summary rows will be a sum of the employee counts, not the last value for the time period. Removing the count function from the measure expression will show the last values (although the incorrect employee numbers will be there due to the count not being applied to the measure expression) If this is design intent, should we update the FM user guide (page 135) to indicate this behavior?
Local fix
Do not use aggregate function in measure expression
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.1 * ****************************************************************
Problem conclusion
Updated in documentation
Temporary fix
Comments
APAR Information
APAR number
PM01959
Reported component name
COG BI FRAMEWK
Reported component ID
5724W12FM
Reported release
830
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-11-23
Closed date
2010-10-28
Last modified date
2010-10-28
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 BI FRAMEWK
Fixed component ID
5724W12FM
Applicable component levels
RA10 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":"830","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 October 2010