APAR status
Closed as program error.
Error description
Reports created in BIA/CWA or RS that take a second or two to run against a sparse PowerCube take upwards of 10 mins or fail to return when zero suppression is enabled. This same report in PowerPlay Studio takes a few seconds.??Customer is a long time user of PP Web, with many business users who frequently leverage the zero suppression functionality in PP Web. They have upgraded to Cognos 10, and are now seeing performance issues when attempting to recreate their reports in Business Insight Advanced, some times so severe that the reports fail to return. An analysis that would return in a few seconds in PP Web is now not returning in BIA after 10 minutes of running. ??These are business users creating these reports, and advanced MDX authoring techniques are not sufficient for them to be able to adequately perform their day to day activities. Furthermore, their data cubes are sparse to handle the business questions they need, and the end reports are not meaningful without removing the zeros. A simple mechanism, like in PP Web is necessary in order for them to get value from the system.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Cognos BI Server 10.2 * * or Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix * * Pack 2 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM66346
Reported component name
COG BUS INSIGHT
Reported component ID
5724W12BI
Reported release
A11
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-06-07
Closed date
2013-03-28
Last modified date
2013-03-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 BUS INSIGHT
Fixed component ID
5724W12BI
Applicable component levels
RA11 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWM","label":"Workspace v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 March 2013