APAR status
Closed as suggestion for future release.
Error description
When setting aggregation rules to 'last', the following issue occurs on 10.1.1 customer environment. - null is displayed for all monthly closing inventory even if some fact data for last date exists. - 'No data available' message is displayed even if the fact data exists. This issue doesn't occur on CQM.
Local fix
use CQM
Problem summary
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix Pack * * 3 * ****************************************************************
Problem conclusion
The Cognos software is behaving as designed. The root cause of the main discrepancies between CQM and DQM for the reports associated with this APAR is that for DMR, aggregate rules of type LAST in CQM will return the last non-NULL value of the measure, while DQM will return the value of the last member in the set whether it is NULL or not. The DQM behavior is intended: it is consistent with OLAP industry standards and is behavior that has been requested by many Cognos 8 customers.
Temporary fix
Comments
No additional comments.
APAR Information
APAR number
PM79179
Reported component name
COG VIEWER
Reported component ID
5724W12CV
Reported release
A11
Status
CLOSED SUG
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-12-13
Closed date
2013-03-12
Last modified date
2013-12-16
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
17 November 2022