APAR status
Closed as program error.
Error description
Cognos is generating poor MDX statements when it's querying an SSAS 2008 cube which has multiple hierarchies in a single dimension. When all the hierarchies are in their own dimension, the performance is much better.
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
PM65342
Reported component name
COG8 BI ANALY S
Reported component ID
5724W12AS
Reported release
A11
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-23
Closed date
2012-09-12
Last modified date
2012-09-12
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 ANALY S
Fixed component ID
5724W12AS
Applicable component levels
RA20 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
06 March 2023