APAR status
Closed as program error.
Error description
8.4.1 Report Studio crosstab report against DMR model shows empty records for all items, when lower level member is dragged into crosstab for the member which does not have records/values in a database. All other items have corresponding values in a database and Report Studio generated query returns those values. If you remove common parent member from upper nesting level or do not drag any children under member that does not have values to report, then there is no loss of data on a report. Tested behaviour with Cognos 'Go Data Warehouse (analysis)' sample DMR model in 8.3 FP5, 8.4 FP2 and 8.4.1 using SQL Server 2005. Happens in customers own model as well, happens against various databases. Using Powercubes datasource similar crosstab shows normally all members on edges and values as empty in measure cells if records are missing.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Cognos BI Server 10.2 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM12365
Reported component name
COG8 BI REPORT
Reported component ID
5724W12RS
Reported release
841
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-15
Closed date
2012-09-11
Last modified date
2012-09-11
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
COG8 BI REPORT
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":"841","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 September 2012